Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: GRANT CONNECT

Re: GRANT CONNECT

From: Alistair <alistair.thomson_at_sphinxcst.co.uk>
Date: Fri, 1 Feb 2002 10:49:21 -0000
Message-ID: <a3drl4$brk$1@thorium.cix.co.uk> 





Hi



Connect to sqlplus as system and type the following:



SQL> spool grant.sql


SQL> select 'grant connect to '||username||';' from dba_users


           where username not in ('SYS','SYSTEM');
SQL> spool of



SQL> @grant.sql



Hope it helps



Alistair



"Manu" <leclerce_at_netcourrier.com> wrote in message
news:a3dm9m$d6r$1_at_reader1.imaginet.fr...


> I would like to know how to grant connect to all the users of a database.

>

Received on Fri Feb 01 2002 - 04:49:21 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US