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

Hans Forbrich wrote:

> Peter wrote:
>
> > How do you grant connection permission to a user?
> > By granting create session privilege?
>
> Depends on how you are trying to accomplish this - the role or the
> privilege method ...
>
> grant connect to {user};
>
> will grant the 'role' with all the required privileges. Last time I
> looked for this, the correlation between the roles and the privileges
> was clearly documented in the SQL Language manual.
>
> I advise you search the documentation for the keyword 'GRANT'. The
> concepts manual also provides useful additional info.

I forgot to mention - the role method is NOT recommended since CONNECT is a carry over from the Oracle6/7 days and carries a lot of additional baggage. Use it as a starting point in your reading. Received on Mon May 26 2003 - 10:32:41 CDT