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

Thread: Object Privelege

  1. #1
    Join Date
    Sep 2002
    Posts
    376

    Object Privelege

    hi,

    In 9i is it possible to Grant object privileges(select,insert,delete) on a Table by a User who doesn't has been granted the object privilege with Grant option, but one who has DBA privilege.

    I mean, Table T1 is present in user A schema.

    Can User B with DBA privelege, grant Select on Table A.T1 to user C, eventhough he has not been granted obj privilege with grant option by A.

    Can somebody answer me.


    (
    I dont have 9i environment. Just was curious to know whether this
    feature is avialable in 9i which was not in 8i
    )

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    Code:
    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.1.0 - Production
    
    SQL> grant create session to a identified by a;
    
    Grant succeeded.
    
    SQL> grant dba to b identified by b;
    
    Grant succeeded.
    
    SQL> grant create session to c identified by c;
    
    Grant succeeded.
    
    SQL> grant create table to a;
    
    Grant succeeded.
    
    SQL> connect a/a
    Connected.
    SQL> create table dummy (dummy date);
    
    Table created.
    
    SQL> connect b/b
    Connected.
    SQL> grant select on a.dummy to c;
    
    Grant succeeded.
    
    SQL>

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: Object Privelege

    Originally posted by bang_dba
    hi,

    In 9i is it possible to Grant object privileges(select,insert,delete) on a Table by a User who doesn't has been granted the object privilege with Grant option, but one who has DBA privilege.

    I mean, Table T1 is present in user A schema.

    Can User B with DBA privelege, grant Select on Table A.T1 to user C, eventhough he has not been granted obj privilege with grant option by A.

    Can somebody answer me.


    (
    I dont have 9i environment. Just was curious to know whether this
    feature is avialable in 9i which was not in 8i
    )
    Possible in 9iR2 and later.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  4. #4
    Join Date
    Sep 2002
    Posts
    376
    Hi,

    Is there any Separate Object privilege to achieve the same.

  5. #5
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    U suerly mean System Privilege ( Aint u )
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  6. #6
    Join Date
    Sep 2002
    Posts
    376
    Originally posted by abhaysk
    U suerly mean System Privilege ( Aint u )
    Yes.

  7. #7
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    GRANT ANY OBJECT PRIVILEGES
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

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