Re: Resize TEMP tablespace datafile

From: Tom <tomNOSPAM_at_teameazyriders.com>
Date: Mon, 26 Jan 2004 10:46:38 -0000
Message-Id: <1075114014.18816.0@nnrp-t71-01.news.uk.clara.net>

> What does
> select username, temporary_tablespace from dba_users;
> reveal?
>
> user_tablespaces are those tablespaces the current user
> has grants on - what privileges does this user have?
> IIRC, no user should have quota on temp tablespace explicitly -
> you are automatically granted that.
> But - when using quota, and you don't explicitly grant,
> it won't show up in user_tablespaces.

ah OK - yes i grant unlimited on TEMP when i create my users - maybe i should stop doing that.

Anyway i can see that if i grant unlimited on TEMP2 it shows up in user_tablespaces

thanks for you help on this

Tom Received on Mon Jan 26 2004 - 04:46:38 CST