Surkov wrote:

> Can I get current database user name, his usergroup and his host name from

> stored procedure?

database user name can be asked using USER

usergroup name using USERGROUP

(for example select user, usergroup into :u1, :u2 from dual)

The machine the database is working on can be asked with

select SERVERNODE from DOMAIN.USERS where USERNAME = USER

The machine your application is working on can be select with

SELECT APPLNODEID FROM SYSDBA.TRANSACTIONS T,
DOMAIN.CONNECTPARAMETERS C
WHERE T.SESSION = C.SESSION

Elke

SAP Labs Berlin