–授予權限
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
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/7529.html
標籤：其他
下一篇：ffmpeg vsync引數分析