-
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
)
-
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>
-
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
-
Hi,
Is there any Separate Object privilege to achieve the same.
-
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"
-
Originally posted by abhaysk
U suerly mean System Privilege ( Aint u )
Yes.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|