Re: Users Question
From: Rüdiger J. Schulz <r.schulz_at_berlin.de>
Date: 1999/02/12
Message-ID: <36C3FFC9.87E3BDC4_at_berlin.de>#1/1
grant connect, resource to xyz;
grant create procedure to xyz;
grant create sequence to xyz;
commit;
Date: 1999/02/12
Message-ID: <36C3FFC9.87E3BDC4_at_berlin.de>#1/1
the system tablespace contains all system tables.
it´s better to store user-data into another tablespace an leave the
system-tablespace allone.
the advantage of this is, that you can backup and restore the
data-tablespace on its own.
so you should create the user with the following options: (i.e.)
Create User xyz identified by abc
default tablespace TS_DATA temporary tablespace TS_TEMP quota unlimited on TS_DATA quota unlimited on TS_TEMP quota unlimited on TS_INDEX;
grant connect, resource to xyz;
grant create procedure to xyz;
grant create sequence to xyz;
commit;
Diego schrieb:
> Hi to everybody
>
> If I create a user with
> create user ....... identified by ....
> This takes at default tablespace the system tablespace. Is this
> dangerous or not?? Why??
>
> Thanks,
> Diego
Rüdiger J. Schulz Received on Fri Feb 12 1999 - 00:00:00 CET