Re: ORA-01031: insufficient privileges

why's it like that?

if system does not have privilege to grant some select on some table to some user ( non-owner), then when you create a role of select privileges on tables in different schemas, you would have to connect to each user and grant select privilege on appro. table, which i guess is not an easy way.
moreover, you require the password of each user to connect.

any other easier way??

regards

In article <80f4gk$840$1_at_nnrp1.deja.com>,   Ben Ryan <benryan_at_my-deja.com> wrote:
> 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.
>

--
Nandakumar
(N.Kumar_at_rocketmail.com)

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