Symptom
- DB user does not have sa_role, but it's aliased as dbo.
- However, when executing sp_helpconstraint '<table>', it reports error 567:
Msg 567, Level 16, State 1: Server 'xxx', Procedure 'sp_helpconstraint', Line 207: 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)
Product
SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise 16.1
Keywords
CR 830572, Error 567, Msg 567, sp_helpconstraint , 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.
SAP Knowledge Base Article - Preview