Re: Creating Users

The dreaded scott/tiger rears its ugly head yet again..

Daniel Morgan answered your question the best way; you really ought to be reading the material before you get into what you are up to, lest you regret it..

A few words on the subject, though:

Make sure all users you create default to the tablespace USERS for their own use and TEMP for their temp space. At a minimum. Keep them out of SYSTEM whatever you need to do.

A well organized project would have, on a pure development system, a huge bloody TEMP space assigned to everyone by default, and individual tablespaces sorted out by project, such as, say, PH_MOLEC_MODEL, PH_CLIN_STUDY, PH_GMP, and so forth, with separate tablespaces to store the related indices that should be on separated areas of storages.

At the end of it, you could create simple SQL*PLUS scripts to do things like

pharm_dev.sql

set echo on
set linesize 132
!rm createuser.log
spool createuser.log
create user &1
default tablespace PH_DEV quota 100 M
temp tablespace TEMP quota unlimited;
grant PH_DEV to &1;
spool off
exit

The role PH_DEV might have system privileges such as: CREATE SESSION (they better have that or they won't be able to log on)

Additionally, the role might have a few other useful aspects such as: CREATE TABLE
CREATE INDEX
CREATE PROCEDURE
and quotas on other tablespaces

and so forth.

"A.K" <a.k._at_nothing.com> wrote in message news:pTtG8.15919$Z6.161630_at_nnrp1.uunet.ca...
> Newbie question?
> Dear All,
>
> How can i add users like "scott" to connect to oracle8i server with the
same
> permissions?
>
> Thanks in advance.
>
>
Received on Tue May 21 2002 - 14:32:21 CDT