Re: granting another users tables ?

bob_at_indigoddb.be.statoil.no (Bo Bell) writes:

> I'm trying to make a DDL script to set up several schemas and tables.
> Although i'm able to create a table in anoter schema, I can't grant
> object rights on the tables to other users (Yes, i'm running the
> script as system (have tried internal and sys also))
 

>Is there a undocumented SYSTEM PRIVILIGE anywhere ?

One of the trickiest of the Oracle system privileges is the GRANT ANY PRIVILEGE privilege. It will allow you to make any system privilege grants you want, but does not allow you to make any object privilege grants. The ground rule is that ONLY the owner of the table or other object has permission to grant privileges on that object when it is first created. The owner of the object may grant privileges with the grant option to another user. Then this second user will have the right to grant any of the rights that he has been granted to other users.

Just another challenge to deal with in life. Received on Mon May 22 1995 - 00:00:00 CEST