[Info-ingres] Installation Password vs DBMS Authentication

Karl Schendel schendel at kbcomputer.com
Thu Sep 9 02:38:16 UTC 2021


On Sep 8, 2021, at 10:12 PM, Steve <s.anderson.au at gmail.com> wrote:
> 
> 
> I turned on DBMS authentication in our development environment and the existing vnodes stopped working.

Right, because with DBMS auth ON, the DBMS is the sole authenticator of Ingres users.  The vnode
username and password is passed to the DBMS, so if you don't have the right username and
password defined in the iidbdb user table to match what's in the vnode, it will fail authentication.

Karl



More information about the Info-ingres mailing list