Can I know who is connecting to my database???

asieraies

Hi,

Can I detect who is connecting to the databse when the database run as a service?? IP, name computer, etc??
For example when Iuser open a company (CodeUnit 1), what's the computer that is opening??
Thanks

Asier

Revolution1210

You can get the Host Name from the Session table.

From the front end, click File, Database, Information. Click the Sessions tab and drill down into Current Sessions - then zoom to see the Host Name field.

If you want to access the information programatically you'll need to acces the system table 2000000009 - Sessions