Re: new users with oracle for linux

From: Andreas Breuer <breuer.andreas_at_gmx.de>
Date: Fri, 11 Jun 1999 16:16:31 +0200
Message-ID: <37611A3F.96BE787F@gmx.de>

Pietro Abate schrieb:

> Hi,
> I've installed oracle server for linux and I want to add some
> users to work with. I've have set via orapwd the passwd for internal user,
> but I don't know how to add other users. I've tried to add a user to my
> system belong to dba group, but the system passwd seems wrong.
>
> How could I add new users ?

The default password for SYSTEM should be MANAGER. Log on as SYSTEM and create new users like this:

create user NEW_USER identified by NEW_USER_PASSWORD default tablespace NEW_USER_TABLESPACE
temporary tablespace NEW_USER_TEMP_TABLESPACE quota unlimited on NEW_USER_TABLESPACE
quota unlimited on NEW_USER_TEMP_TABLESPACE profile DEFAULT;

grant connect to NEW_USER;

If you have the Enterprise-Manager at hand you can user the Security Manager.

Andreas Breuer
Brockhaus Software & Consulting AG Received on Fri Jun 11 1999 - 09:16:31 CDT