Re: Grant object privileges problem

From: Vitaliy Repetenko <vit_at_asu.elcom.ru>
Date: Wed, 24 Feb 1999 13:10:46 +0300
Message-ID: <36D3D026.FA1433D4@asu.elcom.ru>

Violin wrote:

> Hello,
> Could SYSTEM grant scott's object privilege to another user?
> SQL> grant select on scott.emp to ap_user;
> There's an error:
> ORA-01031: insufficient privileges
> How could SYSTEM grant scott's object privilege to another user?
>
> Thank you for help.
> Best Regards.
>
> Violin.
> violin.hsiao_at_mail.pouchen.com.tw

connect scott/pass
grant all on emp to system with grant option; connect system/pass
grant select on scott.emp to ap_user Received on Wed Feb 24 1999 - 04:10:46 CST