Configure database users
In databases, a connection is always stateful, which means that when a connection is established, it must be authenticated.
Configure your database user name and password on the NetScaler appliance. For example, if you have a user John configured on the database, you need to configure the user John on the ADC too. Adding database user names and passwords on the ADC adds them to the
nsconfig file.
Note
Names are case sensitive.
The ADC uses these user credentials to authenticate the clients, and then authenticate the server connections with the database servers.
Related information
Add a database user by using the CLI
At the command prompt, type
add db user <username> - password <password>
Example:
add db user nsdbuser -password dd260427edf
Add a database user by using the GUI
Navigate to System > User Administration > Database Users, and configure a database user.
If you have changed the password of the database user on the database server, you must reset the password of the corresponding user configured on the ADC appliance.
Reset the password of a database user by using the CLI
At the command prompt, type
set db user <username> -password <password>
Example:
set db user nsdbuser -password dd260538abs
Reset the password of database users by using the GUI
Navigate to System > User Administration > Database Users, select a user, and enter new values for the password.
If a database user no longer exists on the database server, you can remove the user from the ADC appliance. However, if the user continues to exist on the database server and you remove the user from the ADC appliance, any request from the client with this user name does not get authenticated. As a result, the request is not routed to the database server.
Remove a database user by using the CLI
At the command prompt, type
rm db user <username>
Example:
rm db user nsdbuser
Remove a database user by using the GUI
Navigate to System > User Administration > Database Users, select a user, and click Delete.