查詢使用者授與角色
SQL> desc user_role_privs;
Name Type Description
USERNAME VARCHAR2(30) Name of the user to whom the role has been granted.
GRANTED_ROLE VARCHAR2(30) Name of the role granted to the user.
ADMIN_OPTION VARCHAR2(3) Whether the user is able to grant the role to another user or role. Equal to YES or NO.
DEFAULT_ROLE VARCHAR2(3) Whether the role is enabled by default when the user connects to the database. Equal to YES or NO.
OS_GRANTED VARCHAR2(3) Whether the role was granted by the operating system.
SELECT * FROM user_role_privs;
沒有留言:
張貼留言