Oracle操作(解锁用户,修改密码,无密码登录,创建表空间,赋权)

ipconfig;

sqlplus /nolog
conn / as sysdba;

alter user scott account unlock;

alter user sys identified by "111";
select empno,ename,job from emp;

EMPNO ENAME JOB
---------- ---------- ---------
7369 SMITH CLERK
7499 ALLEN SALESMAN
7521 WARD SALESMAN
7566 JONES MANAGER
7654 MARTIN SALESMAN
7698 BLAKE MANAGER
7782 CLARK MANAGER
7788 SCOTT ANALYST
7839 KING PRESIDENT
7844 TURNER SALESMAN
7876 ADAMS CLERK

EMPNO ENAME JOB
---------- ---------- ---------
7900 JAMES CLERK
7902 FORD ANALYST
7934 MILLER CLERK

//连接用户两种方法
connect / as sysdba
conn scott/111

alter user sys identified by 新密码;
//赋予连接权限
grant connect to tudou;
//scott用户将权限授权给tudou;
grant select on emp to tudou;
//tudou查看scott的表
select * from scott.tem;//此处用户是scott;tmp表归scott所有；

SYS用户

//创建临时表空间
create temporary tablespace stu_temp
tempfile 'E:\G3T05\oracle\t1\stu_temp.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;

//创建数据表空间

create tablespace stu_data
datafile 'E:\G3T05\oracle\t1\stu_data.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;

//创建用户并指定表空间

create user tudou identified by 111

default tablespace stu_data

temporary tablespace stu_temp;

//给用户授予权限

grant connect,resource to username;