溫馨提示×
您好，登錄后才能下訂單哦！
點擊 登錄注冊 即表示同意《億速云用戶服務條款》
您好，登錄后才能下訂單哦！
#進入數據庫
su - oracle
sqlplus / as sysdba#創建只讀用戶
create user kms identified by "123@456";
grant connect to kms;#給表賦予權限
grant select on ecology.hrmresource to kms;
grant select on ecology.HrmDepartment to kms;
grant select on ecology.HrmSubCompany to kms;
grant select on ecology.hrmjobtitles to kms;#創建同義詞
grant create synonym to kms;
create or replace synonym kms.hrmresource for ecology.hrmresource;
create or replace synonym kms.HrmDepartment for ecology.HrmDepartment;
create or replace synonym kms.HrmSubCompany for ecology.HrmSubCompany;
create or replace synonym kms.hrmjobtitles for ecology.hrmjobtitles;注意：如果不創建同義詞，那么kms用戶查詢表時，必須使用ecology.table這類的寫法，不能直接用table.
免責聲明：本站發布的內容（圖片、視頻和文字）以原創、轉載和分享為主，文章觀點不代表本網站立場，如果涉及侵權請聯系站長郵箱：is@yisu.com進行舉報，并提供相關證據，一經查實，將立刻刪除涉嫌侵權內容。
