Symptom
- When granting select permission on system table, the following error message happened.
use master
go
grant select on sysroles to user_role
go
Msg 2601, Level 16, State 2:
Attempt to insert duplicate key row in object 'sysroles' with unique index 'csysroles '
Msg 11137 , Level 18, State 1:
Failed to add the role 'user_role' into the current database catalogs. - The highest uid in sysusers and the highest Irid in sysroles are different.
E.g)[sysroles]
The highest Irid is 16402 and the role name is 'user_define_role2'
id lrid
43 16402[sysusers]
The highest uid is 16401 and there is no information for the Irid 16402 in sysusers.
suid uid gid name
-2 16401 16401 user_define_role1
Read more...
Environment
SAP Adaptive Server Enterprise (ASE)
Product
SAP Adaptive Server Enterprise 16.0
Keywords
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