Manage Read-Only Database Users#

Remote read-only database access for users can be managed. A username, source IP address and password are required as parameters.

Important

Since the system firewall service is restarted when adding or removing database users, this may affect system operation.

It is therefore strongly recommended that the task be carried out during a maintenance window.

Note

  • When adding a user, a prompt for a password is given. The password rules are:

    • 8 or more characters minimum

    • contains at least 1 uppercase

    • contains at least 1 lower case

    • contains a least 1 digit

    • contains at least 1 punctuation character

  • Adding and deleting users require a service restart.

The following commands and parameters are available:

  • database user add <ip> <username>

  • database user del <ip> <username>

  • database user list

Example console output:

platform@dev:~$ database user list
No users defined
platform@dev:~$ database user add 192.79.22.52 alex
You are about to restart services. Do you wish to continue? yes
New user password:
Please verify password:
platform@dev:~$ database user list
IP  users
192.79.22.52  alex
platform@dev:~$ database user del 192.79.22.52 alex
You are about to restart services. Do you wish to continue? yes
platform@dev:~$ database user list
No users defined