<input id="0qass"><u id="0qass"></u></input>
  • <input id="0qass"><u id="0qass"></u></input>
  • <menu id="0qass"><u id="0qass"></u></menu>

    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 ‘%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

    ??2020 CSDN 皮膚主題: 大白 設計師:CSDN官方博客 返回首頁
    多乐彩