SAP Knowledge Base Article - Preview

3131900 - Granular permission message 16802 - SAP ASE

Symptom

  • When issue a command, message 16802 is returned stating no permission is set to run that command
  • It can be seen for virtually all administrative (non-DML) ASE commands. Below a few examples, just to illustrate the issue :


sp_addserver new_server

Msg 16802, Level 14, State 1
Server 'ASE', Procedure 'sp_addserver', Line 185
You must have the following permission to execute this command/procedure: 'manage server'. Please contact a user with the appropriate permission for help.


sp_addlogin report

Msg 16802, Level 14, State 1
Server 'ASE', Procedure 'sp_addlogin', Line 244
You must have the following permission to execute this command/procedure: 'manage any login'. Please contact a user with the appropriate permission for help.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 & 16.0
  • "enable granular permissions" is ON

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

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.