Subject Re: [firebird-support] I am a new member...
Author Artur Anjos
Hi Carlos,

> I just enjoied this group because I am working in an application
> which uses FireBird.
Welcome!

> 1. How can I know the current user?
SELECT CURRENT_USER FROM RDB$DATABASE;

> 2. How can I know the user's role
You don't. Thsi is the way it works. Users can have many roles. You choose
one to use at connection time.

> 3. How can I know the system date-time?
SELECT CURRENT_TIME,CURRENT_DATE FROM RDB$DATABASE;

Artur