On Mon, Mar 24, 2008 at 5:06 PM, tony_bat <tony_bat@...> wrote:

> I have three different roles and several users.
> When a user logs in how can I determine which role to use. I realize
> the role must be set at login, but if user does not know role name when
> logging in how can I get role name(s) and then relogin using role
> appropriate role.
>
> Tony

I know you can do it in isql like this:

CONNECT 'database path or alias' USER 'username' PASSWORD 'password'
ROLE 'rolename';

as for doing it programmatically, I really never tried and don't know how.

All the best,

Fidel.