例如:
1.
system用户登录
SQL> conn system/oracle
Connected.
2.
将角色授予用户
SQL> grant sales to cat;
Grant succeeded.
3.
将用户cat的所有角色都设为非默认角色,即当用cat用户登录系统时以角色赋予的任何权限都是不能使用的。
SQL> alter user cat default role none;
User altered.
4.
重新将cat用户所有地角色设为默认角色。
SQL> alter user cat default role all;
User altered.
SQL> conn cat/miaomiao
Connected.
SQL> select * from user_role_privs;
USERNAME GRANTED_ROLE ADM DEF OS_
------------------------------ ------------------------------ --- --- ---
CAT MANAGER YES YES NO
CAT SALES NO YES NO
5.将除sales角色之外的所有角色设为默认角色
SQL> conn system/oracle
Connected.
SQL> alter user cat default role all except sales;
User altered.
6.使用cat用户登录查询验证一下:
SQL> conn cat/miaomiao
Connected.
SQL> select * from user_role_privs;
USERNAME GRANTED_ROLE ADM DEF OS_
------------------------------ ------------------------------ --- --- ---
CAT MANAGER YES YES NO
CAT SALES NO NO NO
1.
system用户登录
SQL> conn system/oracle
Connected.
2.
将角色授予用户
SQL> grant sales to cat;
Grant succeeded.
3.
将用户cat的所有角色都设为非默认角色,即当用cat用户登录系统时以角色赋予的任何权限都是不能使用的。
SQL> alter user cat default role none;
User altered.
4.
重新将cat用户所有地角色设为默认角色。
SQL> alter user cat default role all;
User altered.
SQL> conn cat/miaomiao
Connected.
SQL> select * from user_role_privs;
USERNAME GRANTED_ROLE ADM DEF OS_
------------------------------ ------------------------------ --- --- ---
CAT MANAGER YES YES NO
CAT SALES NO YES NO
5.将除sales角色之外的所有角色设为默认角色
SQL> conn system/oracle
Connected.
SQL> alter user cat default role all except sales;
User altered.
6.使用cat用户登录查询验证一下:
SQL> conn cat/miaomiao
Connected.
SQL> select * from user_role_privs;
USERNAME GRANTED_ROLE ADM DEF OS_
------------------------------ ------------------------------ --- --- ---
CAT MANAGER YES YES NO
CAT SALES NO NO NO