用户拥有的系统权限 select privilege from dba_sys_privs where&nbs
用户拥有的系统权限
select privilege from dba_sys_privs where grantee='&USERNAME'
uNIOn
select privilege from dba_sys_privs where grantee in (select granted_role from dba_role_privs where grantee='&USERNAME');
创建用户
CREATE USER songgx
IDENTIFIED BY songgx
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp
QUOTA 10M ON users
PROFILE default
PASSWord EXPIRE
ACCOUNT UNLOCK;
查询用户拥有的系统权限
SELECT *
FROM DBA_SYS_PRIVS
WHERE GRANTEE = 'LIUCH'
UNioN ALL
SELECT *
FROM DBA_SYS_PRIVS
WHERE GRANTEE IN
(SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'LIUCH');
--结束END--
本文标题: oracle中用户角色的查询和授权
本文链接: https://www.lsjlt.com/news/46314.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-14
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0