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 Adaptive Server Enterprise (ASE) all versions

Product

SAP Adaptive Server Enterprise 15.7

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.