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.