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.