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

Thread: Question on Grants

  1. #1
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577

    Question on Grants

    Hi,

    Why cannot a user with DBA priveleges (sys/system etc) grant rights on an object owned by somebody else.

    I mean whats the significance of it when they can do anything they want with the object.... for example drop,alter login as that use etc etc.

    There has to be some logic behind removing this functionality and I dont know about it.

    Thanks
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    if you are using 9i and logon as SYS then you can

  3. #3
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    Originally posted by pando
    if you are using 9i and logon as SYS then you can


    wow... thats great.

    Any reasons why it wasnt there before or was it just an oversight.
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by pando
    if you are using 9i and logon as SYS then you can
    There's a little more to be said about this feature:

    - It's not "any 9i" that offer this, it is only 9iRel2 (9.2) that has this feature enabled
    - You doesn't have to be logged as SYS to use this feature, any DBA account will do (actualy any account that has ben granted new GRANT ANY OBJECT privilege, either directly or via role).
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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