Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: how to alter several users
"Frantz de Germain" <Frantz.de-Germain_at_univ-angers.fr> wrote in message
news:20021128150443.019cd34c.Frantz.de-Germain_at_univ-angers.fr...
> Hello,
>
> I can change quota for one user (alter user foo quota 1M on users;), but
is it
> possible to alter several users in one query, for example, those I can
> retrieve in the following one :
>
> select GRANTEE from DBA_ROLE_PRIVS where GRANTED_ROLE = 'TOTO';
>
> I think yes, but I don't know the syntax.
easiest thing to do is use sql to write sql
select 'alter user '||grantee||' quota 0 on system;' from DBA_ROLE_PRIVS
where GRANTED_ROLE = 'TOTO';
for example.
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ******************************************Received on Thu Nov 28 2002 - 09:13:42 CST