Re: Default tablespace for a suer

I think all quotas are zero by default, if not explicitly set when creating a user.
The real problem is, that lot of people still use connect and resource roles, which they grant to all users.
The resource role has unlimited tablespace privilege and thats why you got lots of crap in system ts.

Tanel.

> Which is why I always create users with zero quota on system.
> Saves this sort of trouble and avaoids IMPort problems later in life.
>
> Cheers,
> Norm.
>
>
> -----Original Message-----
> From: oratune_at_msn.com (David Fitzjarrell) [mailto:oratune_at_msn.com]
> Posted At: Wednesday, June 25, 2003 5:53 PM
> Posted To: server
> Conversation: Default tablespace for a suer
> Subject: Re: Default tablespace for a suer
>
>
> That should show you that SYSTEM is the default tablespace and the
> temporary tablespace ... a scary proposition.
>
> David Fitzjarrell
>
>
Received on Thu Jun 26 2003 - 10:23:26 CDT