OraFAQ Forum: Security » Grant user full access to other schema

Home » RDBMS Server » Security » Grant user full access to other schema

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Grant user full access to other schema [message #661981]

Tue, 11 April 2017 00:19

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.

Report message to a moderator

Re: Grant user full access to other schema [message #661985 is a reply to message #661981]

Tue, 11 April 2017 01:42

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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?

Report message to a moderator

Re: Grant user full access to other schema [message #662017 is a reply to message #661985]

Wed, 12 April 2017 11:12

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Any feedback?

Report message to a moderator

Re: Grant user full access to other schema [message #665135 is a reply to message #662017]

Wed, 23 August 2017 00:12

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

Report message to a moderator

Previous Topic:	Begin to manage and make security
Next Topic:	PDB SYSOPER/SYSDBA privileges

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 15:29:06 CST 2025