| |
Currently Oracle database has a system user SYSUSER have permission to all tables, another system wants to access a table in my database, I do not want him to control all the tables in my database, all I created a new user, the user can only control visit my database a table, with no other permissions.
Specific process is as follows:
1. The system SYS user login
conn sys / password as sysdba
2. Create a user
create user username identified by password
default tablespace user_data
temporary tablespace user_temp;
grant connect, resource to username;
3. The construction of the table tableA, authorization
GRANT ALL ON user A.tableA TO user B;
4. Built synonyms
CREATE SYNONYM user B.tableA FOR user A.tableA; |
|
|
|