Re: ORA-01031: insufficient privileges

From: Ben Ryan <benryan_at_my-deja.com>
Date: Thu, 11 Nov 1999 20:45:47 GMT
Message-ID: <80f9tq$cgh$1@nnrp1.deja.com>

In article <80f8hp$bfi$1_at_nnrp1.deja.com>, Nandakumar <N.Kumar_at_rocketmail.com> wrote:
> 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??

As system create a role called x.
When the user, called y, who owns the tables in question, creates the tables, he or she also grants the neccessary SELECT,UPDATE,.. privileges to the role x.
As system you can grant the role x to any other user, who wishes to access y's tables.

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