how to grant role acces to specific schema
Assuming:
TEST, ADMIN are users
ADMIN is the owner of table TABLE1
TESTROLE is a role
Connect to the schema ADMIN then run command:
GRANT SELECT on TABLE1 to TESTROLE;
Then run the command:
GRANT TESTROLE TO TEST;
connect as TEST user and check:
SELECT * FROM ADMIN.TABLE1;
Bins Ich
Updated on June 13, 2022Comments
-
Bins Ich almost 2 years
I am new to Oracle and i am struggling with the permissions. I created some tables with user called ADMIN on a specific tablespace. The tables are in the schema ADMIN now. I want access this tables from another user called TESTUSER which is in a role called TEST.
Is there a way to grant this role called TEST access to the schema ADMIN? Or a way to grant access to the user for this schema? I aslo want that the ADMIN tables show up in the sqldeveloper under the TEST user.
I already used some commands to try this out but it doesnt work. Eg.
GRANT SELECT on ADMIN.TABLE1 to TEST
What do I have to do?