Re: Why can't SYSTEM grant table privileges?

Hi,

It seems to be impossible for anyone even with DBA permissions to grant rights on objects of another user. Only Fred can grant rights on his objects. One exception - Fred can grant rights to someone with admin otion. Then it is possible to regrant them without Fred.

Andrew Protasov

> I know the answer to this must be in the manuals somewhere but can't
> find it yet. Sorry to ask but can anyone help please?
>
> Running Oracle v7.3.2 on OpenVMS v7.2
>
> If as SYSTEM or SYS in SQLplus or Server Manager in line mode I issue a
> command
> like,
>
> GRANT SELECT ON fred.sometable TO joe;
>
> It refuses with an insufficient privileges message. Why can't SYSTEM
> who has DBA role do this? What do we have to do to allow SYSTEM to do
> this?
>
> Please reply to jmiller_at_norqeb.com.au
Received on Mon Nov 09 1998 - 11:45:41 CST