话不多说,语句如下: --查看具体的用户权限,sys管理员登录时: select * from dba_tab_privs where grantee= '???' select * FROM TABLE_PRIVILEGES where GRANTEE='???'; --查看当前用户的权限,当前用户登录时: select * from user_sys_privs; SELECT * FROM dba_users WHERE account_status <>'OPEN' AND username LIKE '???%'
--查看具体的用户权限,sys管理员登录时:
select * from dba_tab_privs where grantee= '???'
select * FROM TABLE_PRIVILEGES where GRANTEE='???';
--查看当前用户的权限,当前用户登录时:
select * from user_sys_privs;
SELECT * FROM dba_users WHERE account_status <>'OPEN' AND username LIKE '???%'