Re: Granting Access to Non-Owned Tables

From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: 1997/08/20
Message-ID: <33FA7C3B.5A6A@postoffice.worldnet.att.net>#1/1

One other way to achieve what you want (and more !) is to grant the system privilege SELECT ANY TABLE to USERA. Other methods, such as granting SELECT on the table to PUBLIC, or to a role, require the table owner to do the granting.

Hope this helps.

Michael Serbanescu

---

Paul Taylor wrote:
>
> How to I (as DBA) grant access to USERA
> on a table I've just created in USERB schema ?
>
> The only way I've found so far is to connect as USERB and grant myself
> all privileges with the grant option.
>
> There must be an easier way !
>
> Thanks
>
> Paul Taylor
Received on Wed Aug 20 1997 - 00:00:00 CDT