Oracle用戶(hù)只有訪(fǎng)問(wèn)其他用戶(hù)視圖的權(quán)限

Oracle用戶(hù)只有訪(fǎng)問(wèn)其他用戶(hù)視圖的權(quán)限 ：

--創(chuàng)建用戶(hù)
CREATE USER lf IDENTIFIED BY lf
    PROFILE DEFAULT
    DEFAULT TABLESPACE user
    TEMPORARY TABLESPACE temp -
 

    ACCOUNT UNLOCK;

-- 授予權(quán)限
grant create session to query_dqb;
grant select on db_jwb.view_organization to lf;
grant select on db_jwb.view_security_officers to lf;
-- grant select on view_security_officers to lf;
-- 查看用戶(hù)的權(quán)限 角色 對(duì)表的操作
select * from session_roles;
select * from session_privs;
select * from user_tab_privs;

--Oracle--- admin文件  sqlnet文件
SQLNET.AUTHENTICATION_SERVICES= (NONE)

SQLNET.AUTHENTICATION_SERVICES= (NTS)表示操作系統(tǒng)認(rèn)證

exp test/webtec@orcl file=D:/jwb.dmp log=D:/jwb.log
imp test/lf@orac02 file=D:/jwb.dmp full=y

服務(wù)器租用/服務(wù)器托管中國(guó)五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]