Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: CONNECT ROLE
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
![]() |
![]() |