i want to know when does CREATE INDEX priv. is given.
i have these roles on user1 and no other privs on this user
CREATE ANY SYNONYM
DROP ANY SYNONYM
SELECT ANY DICTIONARY
But im able to create index for user1, how it is possible?
Does CREATE TABLE gives permission to create INDEX?
And we have grant CREATE INDEX to username; syntax when does this will be useful?