• 如果您觉得本站非常有看点,那么赶紧使用Ctrl+D 收藏吧

oracle授权查询

互联网 diligentman 1周前 (10-17) 12次浏览

–授予权限
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 ‘%AAAAA%’;

select * from dba_tab_privs;
select * from dba_tab_privs a where grantor=‘AAAA’ and a.owner not in (‘BBBB’) order by a.grantor;
select * from all_tab_privs;
–表查询
select * from user_tab_comments;
select * from user_col_comments


喜欢 (0)