Home » RDBMS Server » Security » Grant user full access to other schema
Grant user full access to other schema [message #661981] Tue, 11 April 2017 00:19 Go to next message
matthiaswolf1984
Messages: 15
Registered: November 2016
Junior Member
Hi,

is there a way to grant a user full access to a other schema?
I know that I can grant the user access to tables and views (and so on) of other users.
The problem I have, what would happen when the other users creates a new table?

For Example:

Schema_1:
Table1
Table2

Schema_2:
Table5

If I grant access to Table1 and Table2 for Schema_2 user it works.
But what would happen if Schema_1 user decides to create a new table f.e. Table3?

Schema_2 user would have no access.


Re: Grant user full access to other schema [message #661985 is a reply to message #661981] Tue, 11 April 2017 01:42 Go to previous messageGo to next message
Michel Cadot
Messages: 65208
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Create a DDL trigger on schema_1 schema which gives that desired privileges to who you want when an object is created.

How did you solve your previous issue?

Re: Grant user full access to other schema [message #662017 is a reply to message #661985] Wed, 12 April 2017 11:12 Go to previous messageGo to next message
Michel Cadot
Messages: 65208
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Any feedback?

Re: Grant user full access to other schema [message #665135 is a reply to message #662017] Wed, 23 August 2017 00:12 Go to previous message
matthiaswolf1984
Messages: 15
Registered: November 2016
Junior Member
Hello Michel,

thanks for you answer.
In the end the application team decided to use one single user.
But good to know that a trigger is the only way.

Thank you
Previous Topic: DBMS_FGA ADD_POLICY
Next Topic: Commonly used root certificates
Goto Forum:
  


Current Time: Fri Nov 24 23:35:06 CST 2017

Total time taken to generate the page: 0.01685 seconds