Now opt a database, and then built several users, such as da, soc and so on, now need to build a user DCL, newly built this user can't other users under the table, table, under construction in front of the table name is combined with the user name, such as create table da. The user, and then used DCL connection can't check this table, such as select * from da. Do not check the user as a result, changes are no more

CodePudding user response:

Through the test, at the time of the new user with the following
The create user DCL cascade;
Grant connect to DCL;
Grant the resource to DCL;
Da so users can only be operated under the table to da users cannot access da, soc

CodePudding user response:

Here need you to give permission, your table under the DCL users want to visit da, da users must give DCL permissions, as follows:
GRANT all on user (this is the name of the table) to DCL. So DCL users can literally operating this table, of course also can let the system user to DCL system permissions assigned permissions

CodePudding user response:

Using the system user login, and then give you create a user to modify the query of the other table permissions

CodePudding user response:

Connect roles include the create session, the resource roles include the create CLUSTER, the create INDEXTYPE, create OPERATOR, the create PROCEDEURE, the create SEQUENCE, create TABLE, create the TRIGGER, the create TYPE privileges, including the create TABLE permissions let users can access all of the tables under this user operation, TO access other users under the TABLE, need TO give another permissions, if want TO da users can access the DCL users under the TABLE, TO GRANT SELECT ON DCL TO da;