ORA-01031 Help me!

[Quoted] [Quoted]    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

When I apply Oracle says:"ORA-01031 insufficient privileges".

I'm logged in as sysdba.

Any idea?

Thanks Received on Fri Sep 20 2002 - 12:14:53 CEST