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: How do you grant connection permission to a user?

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

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Mon, 26 May 2003 19:30:51 +0100
Message-ID: <3ed26474_1@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 Received on Mon May 26 2003 - 13:30:51 CDT

Original text of this message

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