DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Create index privilege

Hybrid View

  1. #1
    Join Date
    Dec 2008
    Posts
    3

    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?

  2. #2
    Join Date
    Apr 2006
    Posts
    377
    If you have CREATE TABLE and the appropriate quota on the tablespace, you are automatically given the privilege to create a conventional index in your own schema.

    Check Prerequisites for CREATE INDEX for additional information.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width