Re: ORA-01031 Help me!

[Quoted] "Simone" <severini.simone_at_vizzavi.it> wrote in message news:2f56752e.0209200214.43e6f1fc_at_posting.google.com...
> 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?

I'm not entirely sure what you want to accomplish since USER=SCHEMA. By default if you log in as the schema owner then you will only have access to [Quoted] that schemas tables.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************