Standard SQL actually has several notions for "current user".
I can't remember them all, but at least there is "effective user" and
"session user".
There may even be an "OS user".

I don't recall any keywords for accessing the current role setting.

Dave

> -----Original Message-----
> From: Claudio Valderrama C. [mailto:cvalde@...]
> Sent: Monday, April 23, 2001 12:37 AM
> To: ib-architect@yahoogroups.com
> Subject: [IB-Architect] SQL names for user and role
>
>
> Hello.
> Is there any name for accessing both user_name and
> user_role in standard
> SQL?
> If there're, are they named current_user and current_role,
> for example?
>
> C.
> ---------
> Claudio Valderrama C.
> Ingeniero en Informática - Consultor independiente
> http://www.cvalde.com
>
>
> To unsubscribe from this group, send an email to:
> IB-Architect-unsubscribe@onelist.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
>
>