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
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.