Granting privilege to anothe schema
614945Jan 13 2010 — edited Jan 13 2010hi all
I have a DB in which there are 2 schemas.
Schema 1 contains some production data and we can not access it.
To access the same we have been given another user schema 2.
Now there are some procedures in schema 1 that have to be run via schema 2.
My question is.
What set of privilege has to be given to schema 2 so that i can run the procedure of schema1.
Do I need to give the required privilege to all the tables/objects being used by that procedure.
Also I have to drop/create some tables in schema1. for that what privilege has to be given on that particular table and how?
Thanks