> SYSDBA users can see other connected users using monitoring tables
> but is it possible to implement such feature for non-SYSDBA users? Are
> there event/triggers that act uppon connecting and disconnecting and
> which can insert usual database records. Triggers no MON$ tables are
> not
You have a few choices in how to do this.
You can either upgrade your users to RDB$ADMIN role rights (not recommended) or
you can grant the user to have rights to a view that gets it's data from a
stored procedure that connects back to the database in a separate
connect/transaction as a user
> SYSDBA users can see other connected users using monitoring tables but is it
> possible to implement such feature for non-SYSDBA users? Are there
> event/triggers that act uppon connecting and disconnecting and which can
> insert
> usual database records. Triggers no MON$ tables are not
>> SYSDBA users can see other connected users using monitoring tables
>> but is it possible to implement such feature for non-SYSDBA users?
The only one who can also "see" connections from user users is the
database owner. Other than that I don't know of a way to do that.
Regards
Stefan
Hi Alain,
We use full user authentication at our company, so everyone logs into the
database using their own credentials. Currently, each user has an account in
the firebird security database. Each user also has a windows domain account.
This means each user has, at a minimum, two
SYSDBA users can see other connected users using monitoring tables but is it
possible to implement such feature for non-SYSDBA users? Are there
event/triggers that act uppon connecting and disconnecting and which can insert
usual database records. Triggers no MON$ tables are not suitable