Oracle beginner - create users

Hi,

I am just a Oracle beginner with sybase background.

I've created a Oracle database server for my group.

Now I need to create users for my group members to access and create all objects of their own, including create table,index,view,stored proc,triggers,etc from sqlplus either local or remote.

What kind of permissions/privileges I need to give to all my users in "create user" statement?

As far as I know, those
should cover create session,create table,create index...

Can somebody provide a standard "create user" statement including proper permission?

thanks,

Paul.     Received on Thu Aug 27 1998 - 21:09:38 CEST