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

Thread: priveledges

  1. #1
    Join Date
    Mar 2001
    Posts
    82

    Unhappy

    If you grant
    "grant REFERENCES to scott"
    "grant all to scott"

    What type of priveledges have you given scott?

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Mar 2001
    Posts
    82
    The link you refered me to did not have the answer that I am looking for.

    ORIGINAL QUESTION

    If you grant
    "grant REFERENCES to scott"
    "grant all to scott


  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Looks like you haven't gone through the documentation properly

    Extracted from the document: http://www.oradoc.com/ora816/server....ch4j4.htm#8815

    ALL [PRIVILEGES] :
    grants all the privileges for the object that you have been granted with the GRANT OPTION. The user who owns the schema containing an object automatically has all privileges on the object with the GRANT OPTION. (The keyword PRIVILEGES is optional.)



    Where as REFERENCES: would allow grantee to REFERENCES
    create a constraint that refers to the table. You cannot grant this privilege to a role. You can only reference on a table and not on other objects like views and etc


    Hope this would clear things for you. Please re-read the document from head to toe once again.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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