Object Privileges by DBA

Oracle9i New Feature Series: Object Privileges by Administrator!

Finally Oracle realized that DBA should have the privilege to grant object privileges. From Oracle9i Release 2 onwards, you need not login as the owner of the object to grant an object privilege. In the earlier releases since most of the time I do not remember the schema password, had to login as the schema using the "back door"!

A new system privilege, "GRANT ANY OBJECT PRIVILEGE" is introduced to control the delegation of an owner's right to grant and revoke object privileges.

In pre-Oracle9iR2 databases, to grant an object privilege on an object that belonged to another user, you should have granted the privilege with the GRANT option.

GRANT ANY PRIVILEGE still gives the grantee privilege to grant any system privilege.

Search BijooS.com Exact Match Search      
Home Oracle DBA TKMCE Alumni H1B Info Guestbook

Biju Thomas is Oracle7.3 OCP, Oracle8 OCP, 
Oracle8i OCP and Oracle9i OCA/OCP Certified DBA

Questions/Comments? Write to webmaster@bijoos.com. The scripts, tips and articles appearing on BijooS.com cannot be reproduced elsewhere without the prior permission from the webmaster.