Re: Granting priveleges

From: Jim Smith <james-detg.smith_at_ubs.com>
Date: 1998/02/20
Message-ID: <34EDB1FE.4F5B26DA@ubs.com>#1/1

A user with DBA privileges (via the DBA role, for instance) can always grant system privileges which is what "SELECT ANY TABLE" is. However, a user cannot grant object privileges on another user's objects unless they have been granted the privilege "with grant option".

Peter Chan wrote:

> I was wondering why I can grant a role to be able to select on all
> tables but unable to grant a role to be able to select on a specific
> table.
> --
Received on Fri Feb 20 1998 - 00:00:00 CST