Re: Granting Access to Non-Owned Tables

Hi Paul !

    Did you try it with

        GRANT right ON USERB.TABLE TO USERA; ?

    Regards

    Dante A. Notari-Locher

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 Tue Aug 19 1997 - 00:00:00 CDT