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