2588760 - sp_displayroles() shows no roles belonging to SYS_UPGRADE_ROLE_ROLE after upgrade | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2588760 - sp_displayroles() shows no roles belonging to SYS_UPGRADE_ROLE_ROLE after upgrade

Symptom

The SQL Anywhere 17 help files say: Upgrading introduce new system privileges, which are automatically added to the UPGRADE ROLE system privilege. You must distribute the privileges granted to the UPGRADE ROLE system privilege to other roles and users, and then revoke them from the UPGRADE ROLE system privilege.

However, upon upgrading from version 12 to version 17, the command:

CALL sp_displayroles ( 'SYS_UPGRADE_ROLE_ROLE', 'expand_down' );

shows no roles.


Read more...

Environment

  • SAP SQL Anywhere 12
  • SAP SQL Anywhere 17 and later

Product

SAP SQL Anywhere 17.0 ; SAP Sybase SQL Anywhere 12.0

Keywords

upgrade, update, roles, permissions, dbsrv12.exe, dbeng12.exe, SQL Central, Sybase Central , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.