用戶與權(quán)限
練習(xí)1.1 創(chuàng)建一個(gè)用戶wangkai鹊奖，并給予10M表空間渐逃。
create user wangkai IDENTIFIED by wangkai
quota 10m on users
1.2 使用管理員賬戶為用戶wangkai分配create session和create table的權(quán)限。
grant create session to wangkai;
grant create table to wangkai
- 修改配額
alter user wangkai IDENTIFIED by wowangkai
[with admin option]允許權(quán)限的接受者再把此權(quán)限授予其他用戶
密碼過期
alter user wangkai password expire
賬戶鎖定/解鎖
alter user wangkai account lock|unlock
回收權(quán)限
drop user wangkai [cascade]
revoke create session from wangkai
將對象權(quán)限給用戶
grant select on scott.emp to wangkai
角色
- 創(chuàng)建角色tr烂完、為角色授予權(quán)限试疙、通過角色為用戶授權(quán)
create role tr;
grant create sequence to tr;
grant tr to wangkai
- 通過角色從用戶收回權(quán)限、從角色收回權(quán)限抠蚣、刪除角色
revoke tr from wangkai;
revoke create sequence from tr;
drop role tr
- 查看DBA效斑、CONNECT、RESOUR角色中包含的系統(tǒng)權(quán)限
select * from DBA_SYS_PRIVS
where grantee='DBA';
select * from DBA_SYS_PRIVS
where grantee='CONNECT';
select * from DBA_SYS_PRIVS
where grantee='RESOURCE';
