Re: ORA-01031: insufficient privileges

From: Ben Ryan <benryan_at_my-deja.com>
Date: Thu, 11 Nov 1999 19:13:35 GMT
Message-ID: <80f4gk$840$1@nnrp1.deja.com>

In article <80f3i7$787$1_at_nnrp1.deja.com>, Nandakumar <N.Kumar_at_rocketmail.com> wrote:
> when i (SYSTEM user) try to GRANT SELECT privilege ON TABLE_A TO user
> USER_B i get the error mesg.
>
> ERROR at line 1:
> ORA-01031: insufficient privileges.
>
> TABLE_A is owned by user USER_A.
>
> ... changing the log on to USER_A , the grant succeedes.
>
> i was under the assumption that SYSTEM can grant/revoke any privilege
to
> any user on any object. am i wrong?

Yes. you are wrong.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 11 1999 - 13:13:35 CST