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.

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