Symptom
- built-in role_name returns stale value when called with NULL role id
- 1> select suser_name(sl.suid), sl.suid, slr.srid, role_name(slr.srid)
2> from syslogins sl left join sysloginroles slr
3> on sl.suid = slr.suid
4> where sl.suid < 3
5> go
------------------------------ ----------- -----------
------------------------------
user 1 0
sa_role
user 1 1
sso_role
user 1 2
oper_role
user 1 3
sybase_ts_role
user 1 10
mon_role
user 1 32
sa_serverprivs_role
probe 2 NULL
sa_serverprivs_role
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7
- SAP Adaptive Server Enterprise (ASE) 16.0
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0
Keywords
role_name, stale value, NULL, role, r0, CR755821, CR#755821, 755821 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
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.
SAP Knowledge Base Article - Preview