How to create a read-only user in the backend PostgreSQL database?
1. Connect to the backend PostgreSQL database where Applications Manager database (AMDB) is stored.
Use the Postgres user for connection. For more details, refer this link.
Use the Postgres user for connection. For more details, refer this link.
2. After connecting to the PostgreSQL database, execute the following queries:
- create user readonly password 'test';
- alter user readonly set default_transaction_read_only = on;
- \c amdb;
- grant usage on schema public to readonly;
- grant select on all tables in schema public to readonly;
After executing the above queries, you can connect to Applications Manager database (AMDB) using the new 'readonly' user and verify the connection.
New to ADSelfService Plus?
Related Articles
Steps to configure Azure PostgreSQL Database as Applications Manager's back-end
Applications Manager comes bundled with PostgreSQL. If you want to use your own PostgreSQL instead, follow the steps mentioned below: Prerequisites: A compatible PostgreSQL database should be accessible from Applications Manager installation. To know ...Maintenance of Applications Manager backend database
Note: Please take complete database backup without fail prior to these steps. I. Applications Manager with PostgreSQL Database. Shutdown all Applications Manager related process as follows: For windows: Open services.msc --> stop ManageEngine ...Connecting to APM Database with Read-Only User
To connect to the database, you will need the following information: Port number: The port in which the Applications Manager database runs. (You can get this from am.db.port value in <Applications Manager Home>\conf\AMServer.properties file). The ...Issues while installing or starting Applications Manager with Microsoft SQL Server backend database
Problem: Unable to install or start Applications Manager using Microsoft SQL Server database as backend. Solution: Follow the below troubleshooting steps to resolve the issue: 1. On the Microsoft SQL server host, go to Start -> All Programs -> ...Issues while upgrading Applications Manager with PostgreSQL backend database
Problem 1: After installing Applications Manager with PostgreSQL as backend (For versions 14850 and above), the following error message is shown due to error the initPGSQLDB.sh file because of missing GLIBC_2.9 library file: ./initdb: ...