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.

Sorry, missed the part where you asked how to get the roles. Once
again, in isql here is how you do it:

SQL>show roles;

Fidel.