Skip to content

What authentication is my Netezza server using?

To check the type of authentication being used by Netezza database server, just run below query in system database. Output of AUTH_VALUE column will be either LOCAL or LDAP.

select * from _v_authentication

AUTH_OPTION AUTH_VALUE
=========== ==========
AUTHENTICATION METHOD LDAP

OR

select * from _v_authentication_settings where AUTH_OPTION = ‘AUTHENTICATION METHOD’;

AUTH_OPTION AUTH_VALUE
=========== ==========
AUTHENTICATION METHOD LDAP

And to check the complete authentication setting for LDAP/LOCAL, just run below query in system database:

select * from _v_authentication_settings

OR

SYSTEM(ADMIN)=> show authentication;
AUTH_OPTION | AUTH_VALUE
———————–+————
AUTHENTICATION METHOD | LDAP

Can also run below for more details:
SYSTEM(ADMIN)=> show authentication all;
AUTH_OPTION | AUTH_VALUE
————————+—————————————————————————
AUTHENTICATION METHOD | LDAP
AUTHMTHD LDAP ATTRNAME | sAMAccountName
AUTHMTHD LDAP BASE | dc=corp,dc=****,dc=com
AUTHMTHD LDAP BINDDN | ****************
AUTHMTHD LDAP PORT | 389
AUTHMTHD LDAP SCOPE | sub
AUTHMTHD LDAP SERVER | *.com
AUTHMTHD LDAP SSL | off
AUTHMTHD LDAP VERSION | 3