Symptom
Wrong suid in sysprocesses when execute store procedure with execute as owner from a other database context.
use master
go
exec tempdb..base_rpc_eao_timeinterval '00:01:00'
go
1> select spid, suid, program_name, status, cmd, dbid, uid
2> from master..sysprocesses
3> where cmd='WAITFOR'
4> go
spid suid program_name status cmd dbid uid
------ ----------- ------------------------------ ------------ ------------------------------ ------ -----------
35 5 isql alarm sleep WAITFOR 2 1
(1 row affected)
1>
use tempdb
go
exec tempdb..base_rpc_eao_timeinterval '00:01:00'
go
1> select spid, suid, program_name, status, cmd, dbid, uid
2> from master..sysprocesses
3> where cmd='WAITFOR'
4> go
spid suid program_name status cmd dbid uid
------ ----------- ------------------------------ ------------ ------------------------------ ------ -----------
35 1 isql alarm sleep WAITFOR 2 1
(1 row affected)
1>
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 15.7 and above
Product
Keywords
suid, sysprocesses, wrong suid, CR 756609 , 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.