Re: Granting table privileges

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 8 Apr 2003 18:03:46 -0700
Message-ID: <2687bb95.0304081703.1f57fac@posting.google.com>

Chuck <chuckh_at_softhome.net> wrote in message news:<Xns935782584BA20chuckhsofthomenet_at_130.133.1.4>...
> Is there a way to grant privileges on a table where the owner has not
> granted you any privileges? IMP seems to have that ability and I am trying
> to duplicate that functionality. I have the "become user" system privilege
> but have not been able to find any SQL or package that will let me do what
> I want.

Up through version 8.1 only the object owner or a user granted privileges with the grant option can grant privileges to a third party.

With version 9+ user SYS also has this ability.

You can create a procedure under the ownership of the object owner and use execute immediate or dbms_sql to issue grants by a non-owner to another non-owner.

Another apporach is to crate a security administrator who is given all privileges on a table with the grant option and via a package have someone administrate object privileges.

HTH -- Mark D Powell -- Received on Tue Apr 08 2003 - 20:03:46 CDT