Schema Grants

[Chucks_k]

Hi all,

I have two schemas.Is it possible to grant SCHEMA2 select,insert,update,delete grants on SCHEMA1 objects at a schema level rather going through each object and grant the priveledges? If so could anyone please let me know?

Thanks in advance,
Chucks

[davey23uk]

no

[gandolf989]

You can grant to a role, and that give that role to the other schema. However, if you need the grants for use in stored procedures then you need direct grants.

[davey23uk]

that wasnt the question, the question was to grant access to all objects in a schema at the same time. Which you cannot do

[Chucks_k]

Thanks Guys,

There is a limitation to this that if SCHEMA1 was add/drop more objects then I would have to the grants for SCHEMA2. Becomes a nuisance if there is a varyin range!

Thanks
Chucks

[davey23uk]

yes it is a nuisance, but a good one in my opinion. If Oracle had this ability it would get abused and people would end up with way more priveleges than they need just because it was quicker to grant all rather than actually work out what was needed