Re: Granting Access to Non-Owned Tables

From: Joe Kazimierczyk <kazimiej_at_bms.com>
Date: 1997/08/20
Message-ID: <33FAD689.4CAE@bms.com>#1/1

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 !
>

Roles make this easier. You only need to be connected as USERB once, in order to grant to some database role. But after that, you can be connected as any DBA type account, and grant that role to other users as needed. It's much easier to admister this way.

---

Joe Kazimierczyk
kazimiej_at_bms.com Received on Wed Aug 20 1997 - 00:00:00 CDT