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

"Paul Brewer" <paul_at_paul.brewers.org.uk> wrote in message news:<3ed26474_1_at_mk-nntp-1.news.uk.worldonline.com>...
> "Peter" <peter_at_nomorenewsspammin.ca> wrote in message
> news:s9p3dvotmmarhun3cng44d59mgifsl4eqj_at_4ax.com...
> > How do you grant connection permission to a user?
> > By granting create session privilege?
> >
> Absolutely correct. The privilege is CREATE SESSION.
> Despite other (misguided) advice in this thread, it is *NOT* the CONNECT
> role, which affords a lot of other system privileges, which you may or may
> not wish to grant.
>
> Regards,
> Paul

Paul and Daniel have it exactly right. You ONLY need CREATE SESSION privilege (Perhaps ALTER SESSION also to change password etc) to successfully connect to the database.

SQL> create user foo identified by foo;
SQL> grant create session to foo;
SQL> grant alter session to foo;

That's it.

Regards
/Rauf Sarwar Received on Mon May 26 2003 - 17:19:03 CDT