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!

Grant to edit and execute a procedure.

misterimranJan 13 2011 — edited Mar 28 2011

Dear All,

My Database is 11gR1 and OS is Linux.

There is a procedure in one of my schema, and i want to assign edit/drop/alter rights of this procedure to a particular DB user.

When i assign rights it says only execute and debug rights can be associate with a user.

When i give debug and execute rights user can not alter the procedure.

Regards, Imran

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 25 2011

Added on Jan 13 2011

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

4 comments

1,720 views