oracle如何查询授权,oracle授权查询

本文介绍了oracle授权查询，小编作为门外汉看了也觉得获益良多，做这类工作的可以参考看看这种美文。

–授予权限

grant insert,select,update,delete on table to user;

grant dba,resource to ytpbl;

grant create any sequence to ytpbl;

–撤销

revoke

REVOKE CONNECT, RESOURCE FROM 用户名;

REVOKE SELECT ON 表名 FROM 用户名;

REVOKE SELECT, INSERT, DELETE ON 表名 FROM 用户名1, 用户名2;

–Oracle查询用户,表相关信息…

–用户

SELECT * FROM DBA_USERS;

SELECT * FROM ALL_USERS;

SELECT * FROM USER_USERS;

–系统权限

SELECT * FROM DBA_SYS_PRIVS;

SELECT * FROM SESSION_PRIVS;

SELECT * FROM USER_SYS_PRIVS;

–角色

SELECT * FROM USER_ROLE_PRIVS;

SELECT * FROM DBA_ROLES;

–对象权限

select * from user_tab_privs ;

select * from user_tab_privs where table_name like ‘

关键词：oracle,授权,查询