cancel
Showing results for 
Search instead for 
Did you mean: 

UDF for User Login

Former Member
0 Kudos
85

Dear all expert,

I want to make query that show usercode that login on this database updated. I will use this information on the SP transaction.

Thanks...

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

On this UDF, you may add a simple FMS query as

SELECT T0.USER_CODE FROM OUSR T0 WHERE T0.INTERNAL_K = $[user\]

Thanks,

Gordon

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

You can used this also,

Select UPPER(T0.Lastname) + ', ' + UPPER(T0.Firstname)  as OWNER from dbo.ohem T0 WHERE T0.Userid = $[USER]

Regards,

Clint

Former Member
0 Kudos

type sp_who2 in sql

u will gt entire detail for more detail apply where condition programname SAP Business One%

Thanks

Kevin