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 previous 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.


 
Read Message
Read Message
Read Message
Read Message
Previous Topic: Begin to manage and make security
Next Topic: PDB SYSOPER/SYSDBA privileges
Goto Forum:
  


Current Time: Thu Apr 18 19:18:52 CDT 2024