Grant user full access to other schema [message #661981] |
Tue, 11 April 2017 00:19 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/9e08465936427f31b646de4e9f9a35bb?s=64&d=mm&r=g) |
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.
|
|
|
|
|
|