SAP Knowledge Base Article - Preview

2631126 - sp_restore_system_role error

Symptom

Trying to recreate a system role with sp_restore_system_role but get errors

Msg 102, Level 15, State 181:
Server '<server_name>', Line 1:
Incorrect syntax near '='.
Restoring '<system_role>' in progress.
Msg 11105, Level 11, State 1:
Server '<server_name>', Line 1:
No such user/role '<system_role>' exists.
Msg 15967, Level 16, State 1:
Server '<server_name>', Procedure '<system_role>', Line 396:
The 'GRANT' command failed when updating permissions to system roles in database
'master'. The roles in the database may not have the correct permissions.
(0 rows affected)
(return status = 0)


Read more...

Environment

Adaptive Server Enterprise

Product

SAP Adaptive Server Enterprise 16.0

Keywords

Fix role, user-defined role, system-defined role, sa_serverprivs_role , 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.