SAP Knowledge Base Article - Preview

3298014 - Is there is way to fetch logins, profiles and authentications using single query? SAP ASE

Symptom

Would like to do a single select to get the information on all logins and their authorizations.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords


logins query, profiles query, authentications query, single query, database roles, user authorizations, syslogins, syssrvroles, sysloginroles, LDAP authentication, PAM authentication, Kerberos authentication, database scripts. , 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 for Me (Login required).

Search for additional results

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