New answers tagged authentication
0
Eventually I found that DB2 UDB does not have its own repository for users, unlike other database servers. DB2 relies on the OS for user management. In Windows, for instance, after creating a UDB user, one has to go into Windows Control Panel/User Accounts and add that same user. Then UDB will allow it to log in with the password, supplied on the OS level. I ...
0
When you have a connection, (ref SHOW CREATE USER),
show create user {user}
will how you the plugin used for any specific user.
SHOW GLOBAL VARIABLE LIKE 'default_authentication_plugin'
will show which authentication is used for created users if none is specified. ref
1
SSL_CLIENT_AUTHENTICATION is a sqlnet.ora parameter - effectively a property of the database itself - not a listener parameter. You can only have one value per database instance (stand-alone or container), so there is no way to have the parameter set differently for separate clients. What you are attempting cannot be done as far as I know.
Top 50 recent answers are included
