Re: Granting table privileges. Possibly Jonathan Lewis can advise here?

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Thu, 10 Apr 2003 00:14:22 +0100
Message-ID: <3e94aa5a_3@mk-nntp-1.news.uk.worldonline.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.

Chuck,

My answer differs from most others (hence the changed heading; Jonathan is an accepted authority). I suspect, however, that Howard knows but isn't telling, and I'm not saying he's wrong with that approach.

Yes. IMP does exactly that, and has done so since 7.3 (or earlier) if my understanding is correct.

Folks; By all means correct me if I'm wrong, but since a *long* while back, with the 'BECOME USER' privilege, one has been able to issue 'alter session set current_schema = nnnnnn' and grant object privileges as necessary.

And I know it's not documented or supported, but if IMP uses it (and I have expressed this opinion since 1997), I think we are safe for a while yet. In any case, as Howard points out, with 9.2 we no longer need it.

Regards,
Paul Received on Wed Apr 09 2003 - 18:14:22 CDT