Re: ORA-01031 Help me!

I'm completely confused as well ...

Simone, as Niall as stated, the 4 schemas you have mentioned are effectively 4 users. You are aware of this ?

Are you trying to create 4 more users (8 users in total) or do you want to grant new privileges to the 4 existing schemas/users ?

Are these 4 new users basically to be granted permission to access the objects in schema/user 1 ?

How precisely are you getting your errors ? While trying to grant the various privileges to the 4 new users or while one of the 4 users is trying to access a table in schema/user 1 ?

Why are the 4 new users being granted the connect and resource roles ? Other than being able to connect to the database (which only requires the create session privilege) and to access the tables in schema 1, do these users need to be able to create a view, create a table, alter a session, create a cluster, create a synonym, create a sequence, create a database link, create a type, create a trigger, create an operation, create an indextype or create a procedure ? If not, why are you granting them these privileges ?

Some further clarification is required I'm afraid (and you thought you were asking the questions ;)

Sorry

Richard
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3d8afc23$0$8506$ed9e5944_at_reading.news.pipex.net...
> "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
> 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
>
> ******************************************
>
>
Received on Fri Sep 20 2002 - 14:10:09 CEST