Question : I have used crypt() in one of my functions to hash user password. But what I observed the […]
Tag: read-only-database
Insert- and Read-only table in Postgres
Question : I want to create an “immutable” Postgres database, where users can insert/select (write/read) data only, but can not […]
Using postgres_fdw to connect from one read replica to another
Question : I have two postgres database servers in AWS, A and B. These databases have different tables. Both databases […]
Create temp tables in Amazon RDS PostgreSQL read-replica
Question : I have dozens of legacy stored procedures which create temporary tables inside for collecting results for a read-only […]
Can we configure logins to only connect to read-only replicas in Azure SQL Database automatically?
Question : For Read-Only routing, rather than explicitly using “ApplicationIntent=ReadOnly” into our application connection string or for individual users to […]
Are there security-issues with a read-only-account on Oracle-DBs?
Question : I am currently working as IT-maintenance-guy for a classic MVC-system(oracle-db/jboss) at public sector. The newest feature should be […]
SQL server Read Only permission automatically for new databases
Question : When I setup my database I create a sql user that my application runs as. The sql user […]
Postgres: permission denied for relation for read_only user [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
Prevent read access on primary AG replica, but allow it on the readable secondary
Question : We have a unique situation where we want to allow users to query a readable secondary replica of […]
Sql server/azure connection string parameter for readonly access?
Question : Is there a specific parameter that can be used in a SQL server/azure connection string to specify that […]