Configuring Database Users

December 21, 2018

Contributed by: C

In databases, a connection is always stateful, which means that as soon as a connection is established, it must be authenticated.

You need to 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. When you add the database user names and passwords on the ADC, these are added 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.

To add a database user by using the command line interface

At the command prompt, type

add db user <username> - password <password>

Example:

add db user nsdbuser -password dd260427edf

To add a database user by using the configuration utility

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.

To reset the password of a database user by using the command line interface

At the command prompt, type

set db user <username> -password <password>

Example:

set db user nsdbuser -password dd260538abs

To reset the password of database users by using the configuration utility

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, and therefore, does not get routed to the database server.

To remove a database user by using the command line interface

At the command prompt, type

rm db user <username>

Example:

rm db user nsdbuser

To remove a database user by using the configuration utility

Navigate to System > User Administration > Database Users, select a user, and click Delete.

The official version of this content is in English. Some of the Citrix documentation content is machine translated for your convenience only. Citrix has no control over machine-translated content, which may contain errors, inaccuracies or unsuitable language. No warranty of any kind, either expressed or implied, is made as to the accuracy, reliability, suitability, or correctness of any translations made from the English original into any other language, or that your Citrix product or service conforms to any machine translated content, and any warranty provided under the applicable end user license agreement or terms of service, or any other agreement with Citrix, that the product or service conforms with any documentation shall not apply to the extent that such documentation has been machine translated. Citrix will not be held responsible for any damage or issues that may arise from using machine-translated content.

Configuring Database Users

December 21, 2018

Contributed by: C

To add a database user by using the command line interface
To add a database user by using the configuration utility
To reset the password of a database user by using the command line interface
To reset the password of database users by using the configuration utility
To remove a database user by using the configuration utility

Edit this article

Configuring Database Users

To add a database user by using the command line interface

To add a database user by using the configuration utility

To reset the password of a database user by using the command line interface

To reset the password of database users by using the configuration utility

To remove a database user by using the command line interface

To remove a database user by using the configuration utility

Configuring Database Users

In this article