Re: Setting up a new user in Oracle 8I personal

There are few steps you need to perform:

1. Create the user
2. Grant a default tablespace and temporary tablespace
3. Grant login privileges to the user
4. Grant object privileges
5. Grant quota on the default tablepsace on the user

Connect to the database as sys
Step 1&2:
Create user <userName>
identified by <password>
default tablespace <tablespacename>
temporary tablespace <tablespacename> ;

Step 3, 4:
grant connect, resource, dba to <username> ;

Step 4:
alter user <username> quota unlimited on <DefaultTablespaceName> ;

This should work.

Cheers
Biz

On Sun, 26 May 2002 02:14:40 GMT, "B.Hanley Jr." <streetsweepa1_at_comcast.net> wrote:

>How do I create a new user in Oracle 8I personal. I an tired of using the
>default user Scott.
>
>
  Received on Thu May 30 2002 - 18:40:14 CEST