SAP Knowledge Base Article - Preview

1973263 - Wrong suid in sysprocesses when execute store procedure with execute as owner from a other database context - SAP ASE

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

SAP Adaptive Server Enterprise 15.7

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.