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

From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Mon, 26 May 2003 14:19:49 GMT
Message-ID: <3ED22110.1D2547DE@telusplanet.net>

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. Received on Mon May 26 2003 - 09:19:49 CDT