Re: Creating Users

I am not convinced that we did, at all.

In any case, separating the table tablespaces and the index tablespaces logically, if not physically, at the beginning, surely makes management easier in many ways. I like to know where all my tables and all my indices live and having them in separated tablespaces has made life easier for me.

In any case, I'd hope you would agree that creating users defaulting to SYSTEM is not a good thing. :)

RSH. "Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3CEAA1C0.4CDDA2CA_at_exesolutions.com...
> 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:47:03 CDT