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.