Good afternoon. I have two owners on my oracle example Owner "X" and the other owner "Y". Where each one has its own tables, but I want the owner "X" to be able to update, insert and delete some tables of the owner "Y". Is it possible?
ORACLE USERS
0
asked by anonymous 14.08.2018 / 21:48
1 answer
2
Yes, it is possible! You must grant ( GRANT ) the appropriate permissions for USER / ROLE.
To create the specific permission for table would be using the following command:
GRANT SELECT, INSERT, DELETE, UPDATE ON Y.TABELA to X
15.08.2018 / 13:42