Shulou(Shulou.com)06/01 Report--

# enter the database

Su-oraclesqlplus / as sysdba

# create a read-only user

Create user kms identified by "123-456"; grant connect to kms

# Grant permissions to tables

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

# create synonyms

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

Note: if synonyms are not created, kms users must use words such as ecology.table when querying the table, not table.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.