Re: Changing a user's default tablespace.

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Mon, 07 Jun 2004 21:03:56 +0200
Message-ID: <ca2dui$iba$1@news5.tilbu1.nb.home.nl>

Dave wrote:

> "Paul" <paul_at_not.a.chance.ie> wrote in message
[snnip!]
> if you change quota to 0 on that tablespace then you will get an error when
> you try to create any object - however if you have dba rights then it will
> work as you have the 'unlimited tablespace' privelege
>
>

Actually - in 9iRel2, resource role will be enough (still; since 8.0)

-- 

Regards,
Frank van Bortel

Received on Mon Jun 07 2004 - 14:03:56 CDT