Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to grant access to current and future objects in a schema?

2675887May 19 2014 — edited May 19 2014

Hi,

This is puzzling me for a while now and the oracle developers are asking me to come up with a permanent solution.

Currently I give them to objects that are already created in the schema but how can I give developers access to future objects created in a schema? I don't want to have to give them access after they create every table/view, give them 'any' access, and I don't want to use triggers.

Can anyone help?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 16 2014

Added on May 19 2014

#11g, #database, #general-database-discussions

4 comments

679 views