SAP Knowledge Base Article - Preview

3079453 - Error on granting select permission to user defined role - SAP ASE

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.