Re: ORA-01031 Help me!

3 things:
Never grant resource - use specific grants instead - most users do not need all the rights resource grants You need not grant select any dictionary AFAIK Even as a sysdba you cannot grant rights to objects in another user's schema unless that schema owner ( the user) has granted you admin rights ...

Each user ( or you logged in as each user) can create grant the explicit privs the other users need for the objects in their schema...

severini.simone_at_vizzavi.it (Simone) wrote:

>Hi,
> I've got 4 schema in my database with the same set of table but of
>course dirrent data. I'd like to create 4 set of user in such a way
>that user1 can only access to schema1 and sono user2 to schema1 and
>user3 to schema2 ...
>
>To do it I've performed the following operations:
>
>User creation as
> Role: connect and resource,
> System Privileges: select any dictionary;
> Object Privileges: select/inser/update some table of the
>schema1
>
>
>
>When I apply Oracle says:"ORA-01031 insufficient privileges".
>
>I'm logged in as sysdba.
>
>Any idea?
>
>Thanks

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Fri Sep 20 2002 - 15:59:39 CEST