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

To check the dynamic balance of the business department, you need to query the data of the four tables in the mes system, create a dphuser account for it, and give it only query permissions! The specific steps are as follows:

1. Log in to create an account with sys users and grant permissions!

Sqlplus / as sysdba

Create user dphuser identified by 123456

Grant connect,resource to dphuser

2. Give the query authority to the four tables under the mes account!

Grant select on mes.ssb_user to dphuser

Grant select on mes.ssb_work to dphuser

Grant select on mes.ssb_class to dphuser

Grant select on mes.cpp_curing_productionto dphuser

Grant select on mes.sbm_material todphuser

3. Log in with a new user to test whether you can query it!

Sqlplus dphuser/123456@orcl

SQL > select count (*) from mes.ssb_user

COUNT (*)

-

four hundred and eighty

SQL > select count (*) from mes.ssb_work

COUNT (*)

-

seventy-seven

SQL > select count (*) from mes.ssb_class

COUNT (*)

-

three

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.