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: oracle 9i connection string with SYS account

Re: oracle 9i connection string with SYS account

From: tojo <TomJordanTojo_at_hotmail.com>
Date: Tue, 4 Jun 2002 19:40:03 +0200
Message-ID: <MPG.176719e0582fbc81989692@news.t-online.de>


In article <3CFCD6F5.1D40219A_at_exesolutions.com>, dmorgan_at_exesolutions.com says...
> The first thing I do to a
> new database after changing the SYS and SYSTEM passwords is drop CONNECT and
> create a role that actually provides appropriate access. To many people think
> CONNECT is the privilege to connect to the database and that just isn't the
> case.
>
>

Could you please tell me what privileges you grant to the new connect role? What else besides CREATE SESSION?

Thanks,
Tom Received on Tue Jun 04 2002 - 12:40:03 CDT

Original text of this message

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