Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> how to alter several users
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.
I'm on oracle 8.0.5
Regards
-- Frantz de GERMAIN E-mail : Frantz.de-Germain_at_info.univ-angers.fr Web : http://frantz.free.fr Membre de la Société d'Astronomie de Nantes : http://www.san-fr.com/Received on Thu Nov 28 2002 - 08:04:43 CST