Re: How do you grant connection permission to a user?

Sander Goudswaard wrote:

> Peter <peter_at_nomorenewsspammin.ca> wrote in
> news:s9p3dvotmmarhun3cng44d59mgifsl4eqj_at_4ax.com:
>
> > How do you grant connection permission to a user?
> > By granting create session privilege?
> >
>
> grant connect to luser;
>
> - Sander

That is not correct. Connect is a role that has absolutely nothing to do with connecting to the database.

The role contains the create session privilege which is why it works.

The connect role should never be granted to any user and, in fact, should be dropped about as fast as
change_on_install.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)