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;