oracle权限怎么查询

如何查看oracle用户具有的权限和角色

①查看所有用户：

select * from dba_users;

select * from all_users;

select * from user_users;

select * from dba_sys_privs;

select * from user_sys_privs;

sqlselect * from role_sys_privs;

select * from dba_tab_privs;

select * from all_tab_privs;

select * from user_tab_privs;

select * from dba_roles;

oracle中怎样查询用户权限?

查看用户系统权限：\x0d\x0aselect * from dba_sys_privs;\x0d\x0aselect * from session_privs;\x0d\x0aselect * from user_sys_privs;\x0d\x0a查看用户对象权限：\x0d\x0aselect * from dba_tab_privs;\x0d\x0aselect * from all_tab_privs;\x0d\x0aselect * from user_tab_privs;

如何查看oracle用户权限

"ORACLE数据字典视图的种类分别为：USER,ALL 和 DBA.

USER_*:有关用户所拥有的对象信息,即用户自己创建的对象信息

ALL_*:有关用户可以访问的对象的信息,即用户自己创建的对象的信息加上

其他用户创建的对象但该用户有权访问的信息

DBA_*:有关整个数据库中对象的信息

(这里的*可以为TABLES,INDEXES,OBJECTS,USERS等.)

①.、查看所有用户

select * from dba_user;

select * from all_sys_privs;

select * from dba_role_privs;

select * from user_role_privs;

select username,default_tablespace from user_users;

如grant connect,resource,create session,create view to TEST;

用SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE='RESOURCE

"

以上就是土嘎嘎小编为大家整理的oracle权限怎么查询相关主题介绍,如果您觉得小编更新的文章只要能对粉丝们有用,就是我们最大的鼓励和动力,不要忘记讲本站分享给您身边的朋友哦！！