[newbie] 2 questions about granting a role to a user

From: Franz <franz_at_mail.com>
Date: Wed, 01 Oct 2003 06:52:30 GMT
Message-ID: <OQueb.2447$Sf.77558@twister1.libero.it>

hi all dba!
I'd like to grant a role (tat I have called basic) to a user...here are my steps...

SQL>connect / as sysdba;
SQL>create role basic;
SQL> grant create session,create table,insert any table,select any

table,update any table,delete any table to basic;

SQL>alter user franz default role basic

alter user franz default role basic
*

ERRORE alla riga 1:
ORA-01955: DEFAULT ROLE 'BASIC' not granted to user

Why I'm not allowed to rant "basic" role to the user ?

Also: how can I obtain that a role as unlimited quota on a tablespace? (I don't want every time
that I create a user to specify his/her quota on the tablespace)

grant unlimited tablespace to basic
*

ERRORE alla riga 1:
ORA-01931: Impossible to grant UNLIMITED TABLESPACE to a role Thanks a lot
Franz Received on Wed Oct 01 2003 - 01:52:30 CDT