Symptom
Wrong ServerUserID in monSysSQLText when execute procedure with "execute as".
select suid, name from master..syslogins
go
suid name
----------- ------------------------------
1 sa
2 probe
3 jstask
4 test_user
5 rpctest
use tempdb
go
select @@spid
go
------
42
exec tempdb..base_rpc_eao_timeinterval '00:01:00'
go
select * from monSysSQLText where SPID in (select spid from master..sysprocesses where cmd = 'WAITFOR')
go
SPID InstanceID KPID ServerUserID BatchID SequenceInBatch SQLText
----------- ---------- ----------- ------------ ----------- --------------- -----------------------------------------------------------------------------------
42 0 9240647 5 1 1 use tempdb
42 0 9240647 5 2 1 select @@spid
42 0 9240647 5 3 1 exec tempdb..base_rpc_eao_timeinterval '00:01:00'
select mpa.SPID 'mpaSPID', mpa.ServerUserID 'mpasuid', mp.ServerUserID 'mpsuid', sp.suid, sp.program_name from master..sysprocesses sp, master..monProcessActivity mpa, master..monProcess mp where sp.spid=mpa.SPID and mp.SPID=mpa.SPID
and sp.cmd='WAITFOR'
go
mpaSPID mpasuid mpsuid suid program_name
----------- ----------- ----------- ----------- ------------------------------
42 1 1 1 isql
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) all versions
Product
Keywords
suid, monSysSQLText, ServerUserID, CR756770, CR 756770, 756770 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview