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

Home -> Community -> Usenet -> c.d.o.server -> Re: Granting 'connect' role- which 7 privilages it gives ?

Re: Granting 'connect' role- which 7 privilages it gives ?

From: <ricforduk_at_yahoo.co.uk>
Date: 3 Oct 2005 06:27:51 -0700
Message-ID: <1128346071.935021.234720@o13g2000cwo.googlegroups.com>

But be aware of the change in 10.2

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Oct 3 14:22:51 2005

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options

SQL> select privilege from dba_sys_privs where grantee='CONNECT' order by 1;

PRIVILEGE



CREATE SESSION SQL> Received on Mon Oct 03 2005 - 08:27:51 CDT

Original text of this message

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