Re: Grant object privileges problem

From: John Koo <johnkoo_at_whale.i-wave.net>
Date: 24 Feb 1999 03:53:44 GMT
Message-ID: <7avt48$n1n50@news.hk.linkage.net>

Violin (violin.hsiao_at_mail.pouchen.com.tw) 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

Hi violin,
SYSTEM user is a powerful one but in order to grant a object privilege to someone else, one of the following conditions must be fulfiled: 1) you own the object; or
2) you have been granted the object privilege with WITH GRANT OPTION; See ??

John Koo from Hong Kong
johnkoo_at_i-wave.net Received on Tue Feb 23 1999 - 21:53:44 CST