只有角色是使用with ADMIN option选项的GRANT语句授予的或者具有alter any
role系统权限的用户时,才可以修改这个角色。
如下:
SQL> alter role clerk identified externally;
Role altered.
SQL> alter role sales
2 not identified;
Role altered.
SQL> alter role manager identified by vampire;
Role altered.
查询一下:
SQL> select * from dba_roles where role in ('CLERK','SALES','MANAGER');
ROLE PASSWORD
------------------------------ --------
CLERK EXTERNAL
SALES NO
MANAGER YES
role系统权限的用户时,才可以修改这个角色。
如下:
SQL> alter role clerk identified externally;
Role altered.
SQL> alter role sales
2 not identified;
Role altered.
SQL> alter role manager identified by vampire;
Role altered.
查询一下:
SQL> select * from dba_roles where role in ('CLERK','SALES','MANAGER');
ROLE PASSWORD
------------------------------ --------
CLERK EXTERNAL
SALES NO
MANAGER YES