Re: Creating Users

RSH wrote:

> 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.
> >
> >

I really sorry ... really really sorry ... I don't want to start this again but above you wrote:

"with separate tablespaces to store the related indices that should be on separated areas of storages"

Didn't we just stick a knife in this one?

Daniel Morgan Received on Tue May 21 2002 - 14:36:44 CDT