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

nirav wrote:
> 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.

select privilege from dba_sys_privs where grantee='CONNECT'; Received on Mon Oct 03 2005 - 07:18:58 CDT