ORA-01031: insufficient privileges

From: Nandakumar <N.Kumar_at_rocketmail.com>
Date: Thu, 11 Nov 1999 18:57:20 GMT
Message-ID: <80f3i7$787$1@nnrp1.deja.com>

Hi,

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?

--
Nandakumar
(N.Kumar_at_rocketmail.com)

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