oracle用户管理

connect sys/12345678 as sysdba


create user jsx identified by 123456;


grant create session to jsx;


grant create table to jsx;


connect jsx/123456


create table xs(xh int);


create user jsx2 identified by 123456 password EXPIRE;


grant connect to jsx2;


connect jsx2/123456


alter user jsx3 account lock;  //修改为锁定状态


connect jsx2/123456  // 再次连接会失败


alter user jsx3 account lock;  //修改为解锁状态




创建用户JIA 该用户采用数据库口令认证方式强制要求首次登陆时必须修改口令，将其默认表空间和临时表空间分别设置为USERS和TEMP并在USERS表空间上为其分配10M表空间限额


CREATE USER jia 
IDENTIFIED BY 123456
PASSWORD EXPIRE
DEFAULT TABLESPACE users
QUOTA 10M ON users
TEMPORARY TABLESPACE temp;


练习:


CREATE TABLESPACE ts1
DATAFILE 'D:\ts01.dbf' SIZE 20M REUSE; //创建
表空间


CREATE TEMPORARY TABLESPACE temp1
TEMPFILE 'D:\temp01.dbf' SIZE 20M REUSE; //创建
临时表空间


CREATE USER jiashixin 
IDENTIFIED BY 123456
TEMPORARY TABLESPACE temp1 
DEFAULT TABLESPACE ts1 
QUOTA 10M ON ts1; //创建
用户


CREATE USER user4 
IDENTIFIED BY 123456
TEMPORARY TABLESPACE temp1 
DEFAULT TABLESPACE ts1 
QUOTA 10M ON ts1
QUOTA 10M ON temp1;   //错误创建
用户命令   只能在永久表空空间上分配限额


CREATE USER user6 
IDENTIFIED BY 123456
TEMPORARY TABLESPACE temp1 
DEFAULT TABLESPACE ts1 
QUOTA 10M ON ts1
QUOTA 10M ON users;   //创建
用户命令  可以同时在多个永久表空间分配限额




ALTER USER user6 IDENTIFIED BY 123456789;


ALTER USER user6 QUOTA 5M ON USERS;
 
DROP USER user6;  //CASCADE  可删除与之相关联的对象