-
Create index privilege
i want to know when does CREATE INDEX priv. is given.
For Eg.
i have these roles on user1 and no other privs on this user
CREATE ANY SYNONYM
CREATE SESSION
CREATE TABLE
CREATE VIEW
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|