Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do you grant connection permission to a user?
"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