Symptom
- What is the meaning of "Authenticate with: AUTH_DEFAULT" in sp_displaylogin?
- Which authentication mechanism is used in case of "AUTH_DEFAULT"?
Loginame: sa
Fullname:
Default Database: master
Default Language:
Auto Login Script:
Configured Authorization:
sa_role (default ON)
sso_role (default ON)
oper_role (default ON)
sybase_ts_role (default ON)
ha_role (default ON)
mon_role (default ON)
js_admin_role (default ON)
js_user_role (default ON)
sa_serverprivs_role (default ON)
mytest (default OFF)
Locked: NO
Date of Last Password Change: Oct 17 2018 6:12PM
Password expiration interval: 0
Password expired: NO
Minimum password length: 6
Maximum failed logins: 0
Current failed login attempts:
Authenticate with: AUTH_DEFAULT
Login Password Encryption: SHA-256
Last login date: Nov 3 2021 4:16PM
Exempt inactive lock: 0
(return status = 0)
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) all versions
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0
Keywords
SAP ASE authentication mechanisms, AUTH_DEFAULT explanation, sp_displaylogin AUTH_DEFAULT, ASE external authentication, LDAP authentication ASE, PAM authentication ASE, KERBEROS authentication ASE, ANY authentication ASE, ASE login creation, SAP ASE server authentication, ASE mechanism default, AUTH_DEFAULT login details, SAP ASE roles, ASE password encryption, SHA
- 256 encryption ASE, SAP ASE login troubleshooting
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