SAP Knowledge Base Article - Preview

2266857 - sp_helptext raises Error 567 when "select on syscomments.text" disabled

Symptom

The sp_helptext  system stored procedure returns Error 567:

Msg 567, Level 16, State 1:
Server 'SYBASE', Procedure 'sp_helptext', Line 224:
You must have the following role(s) to execute this command/procedure: 'sa_role'. Please contact a user with the appropriate role for help.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) all versions

Product

SAP Adaptive Server Enterprise all versions

Keywords

syscomments, text, sp_configure, configuration, installmaster, 794585, CR794585 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.