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

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 3 Oct 2005 14:27:39 +0200
Message-ID: <43412396$0$6509$626a14ce@news.free.fr>

"nirav" <shivam71_at_gmail.com> a écrit dans le message de news: 1128340408.548644.186580_at_z14g2000cwz.googlegroups.com...
| Hello,
|
| Can you tell me that granting the role "connect" to a user gives which
| privilages to the user? -I read in a book that it grants some 7
| different privilages , but I dont know which one.
|
| The reason is: after granting this privilage the user who has been
| granted this privilage can create his objects even in system
| tablespace! and even after altering the user so that his quota on
| system is 0, still he can create in system tablespace! - This is rather
| surprising and so i want to know which distinct privilages are bundled
| in this role.
|
| thx.
| S.
|

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

---

ALTER SESSION
CREATE CLUSTER
CREATE DATABASE LINK
CREATE SEQUENCE
CREATE SESSION
CREATE SYNONYM
CREATE TABLE
CREATE VIEW 8 rows selected.

Regards
Michel Cadot Received on Mon Oct 03 2005 - 07:27:39 CDT