oracle permissions
631319Oct 30 2008 — edited Oct 30 2008Hi 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