I have recently configured LDAP in POC and soon moving to production.
dbadmin=> create user "skumar01";
CREATE USER
dbadmin=> GRANT AUTHENTICATION LDAP1 to "skumar01";
GRANT AUTHENTICATION
[dbadmin@infra-vertica-1 ~]$ vsql -U "skumar01" -h 10.42.00,109 -w 'Password' -c "select user_name, client_authentication_name from sessions";
user_name | client_authentication_name
---------------+----------------------------
skumar01 | LDAP1
Now i am moving it in prod but i have a situation-
a) In Production my vertica db username is sk25243 but my ldap username is skumar01.
Is there any way to grant ldap authentication to sk25243 without changing my username.
Offcourse the other way would be to RENAME sk25243 TO new-user-name( skumar01)ie my LDAP username.