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 -> Granting 'connect' role- which 7 privilages it gives ?

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

From: nirav <shivam71_at_gmail.com>
Date: 3 Oct 2005 04:53:28 -0700
Message-ID: <1128340408.548644.186580@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. Received on Mon Oct 03 2005 - 06:53:28 CDT

Original text of this message

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