0
Good afternoon. I have two Owners on my oracle example Owner "X" and other Owner "Y". Where each has its own tables, but I want Owner "X" to be able to update, Insert and delete some Owner "Y" tables. And possible?
1 answer
2
Yes, it is possible! It is necessary to grant(GRANT) the appropriate permissions for the 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
Browser other questions tagged oracle oracle11g
You are not signed in. Login or sign up in order to post.
Possible duplicate of Permissions for an Oracle USER, related: https://answall.com/questions/235802/grant-para-varias-tabelas-oracle
– Barbetta