Re: exporting from Oracle8 using Exp80

From: Ales Kavsek <kavsek_at_yahoo.com>
Date: Thu, 19 Aug 1999 15:37:21 +0200
Message-ID: <7ph18k$1er$1@sigov1.sigov.si>

> Now when creating a User from scratch, can you grant the unlimited
> tablespace on just one tablespace? I always thought that unlimited
> tablespace was just for the User's default tablespace.
>

Hi,

I think it's good practise revoking UNLIMITED TABLESPACE system privilege from the user after granting him RESOURCE role. Then you can grant him unlimited tablespace for default tablespace.

SQL> grant connect, resource to <user>;
SQL> revoke unlimited tablespace from <user>;
SQL> alter user <user> quota unlimited on <tablespace>;

bye,
Ales Received on Thu Aug 19 1999 - 08:37:21 CDT