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
Attachment: [text/html]
Attachment: [text/html]
