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: CONNECT ROLE

Re: CONNECT ROLE

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 27 Aug 2002 13:25:48 +0100
Message-ID: <3d6b6fcd$0$8509$ed9e5944@reading.news.pipex.net>


Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:qnfmmu4ruvfebld1n3p509u0shlguurfo8_at_4ax.com...
> How many users, do you think, *really* need the privilege to create a
> table (I'm not referring to sqlserver apps, ported to Oracle ;)
> 1 percent, 2 percent?
> Yet everyone I know grants the CONNECT role indiscriminately to all
> users, while CREATE SESSION priv would have been sufficient.

I entirely accept this, and I really don't think the name helps, but the criticism seems to be aimed at the existence of the role rather than the DBA not thinking when granting privileges.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
Received on Tue Aug 27 2002 - 07:25:48 CDT

Original text of this message

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