SAP Knowledge Base Article - Preview

1973827 - Wrong ServerUserID in monSysSQLText when execute procedure with "execute as" - SAP ASE

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         isql

 


Read more...

Environment

SAP Sybase Adaptive Server Enterprise (ASE) all versions

Product

SAP Adaptive Server Enterprise 15.7

Keywords

suid monSysSQLText ServerUserID , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.