Re: how to alter several users

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Fri, 29 Nov 2002 11:24:15 +0100
Message-ID: <6ufeuu8gt175a55k31r8s7r2aa61pq87dn@4ax.com>

On Fri, 29 Nov 2002 10:34:32 +0100, Frantz de Germain <Frantz.de-Germain_at_univ-angers.fr> wrote:

>I made a test on one user and one role and I had the following result :
>
>SQL> select 'alter user '||grantee||' quota 1m on users ;' from DBA_ROLE_PRIVS
>SQL> where GRANTED_ROLE = 'ROLETEST';
>
>'ALTERUSER'||GRANTEE||'QUOTA1MONUSERS;'
>-------------------------------------------------------------
>alter user SYSTEM quota 1m on users ;
>alter user TOTO quota 1m on users ;
>
>As you can see the user SYSTEM has been altered and this could be a problem.
>

So exclude the user SYSTEM.

The docs if any will be found in the sql*plus reference manual, and the Oracle Application Developers Manual. But really this doesn't need to be documented, because as soon as you realise sql*plus can spool to a file and you can execute a file from sql*plus, the next step is easy.
No need to recall old commands by means of some fancy GUI

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Nov 29 2002 - 04:24:15 CST