Skip to Main Content

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!

oracle permissions

631319Oct 30 2008 — edited Oct 30 2008
Hi all,

Sorry for asking what may seem to be a pretty dense question, but I want to confirm my understanding on something.

Here it is:
It is my understanding that it is not possible to grant permission to drop a specific index. Rather, the permission to drop indexes is made to all:
GRANT DROP ANY INDEX TO user. I would like to be able to specifiy: GRANT DROP INDEX schema.index_name TO user_name, but I don't think that this is permissible.
True?

Similarly with TRIGGERS: I would like to be able to make grants specific to a trigger, but I don't think that this is allowed. Instead, I must issue the following:
GRANT ALTER ANY TRIGGER TO user. Whereas I would like to issue the following command: GRANT ALTER TRIGGER trigger_name TO user_name, but this is not allowed.
True?

Thanks for the clarification,

Tom
This post has been answered by 448778 on Oct 30 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 27 2008
Added on Oct 30 2008
4 comments
5,709 views