Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: read-only-database

Do I need to execute “create extension pgcrypto” everytime?

By adminPosted on December 18, 2022

Question : I have used crypt() in one of my functions to hash user password. But what I observed the […]

Insert- and Read-only table in Postgres

By adminPosted on October 17, 2022

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

By adminPosted on October 14, 2022

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

By adminPosted on September 7, 2022

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?

By adminPosted on July 26, 2022

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?

By adminPosted on June 16, 2022

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

By adminPosted on June 13, 2022

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]

By adminPosted on May 27, 2022

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

By adminPosted on May 5, 2022

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?

By adminPosted on April 18, 2022

Question : Is there a specific parameter that can be used in a SQL server/azure connection string to specify that […]

  • 1
  • 2
  • 3
  • 4

Recent Posts

  • How can one identify if FK’s needed to be indexed apart from the NC indexes already residing
  • INSERT array elements from JSON object as table rows
  • Table design for efficiently retrieving “most recent row” per FK’d item whose PK is a GUID
  • Why does my BETWEEN predicate not match any rows? [closed]
  • MySQL using a index referencing a different column
  • mysql – Recovering databases from ibdata1 , .frm and .idb
  • Postgres: What could cause the error “cannot call populate_composite on a scalar”?
  • Safely changing innodb_buffer_pool_size on MySQL replication master?
  • Why my index don’t update?
  • MySQL – What exactly does smallint(2) permit? [duplicate]
  • Optimize a slow nested loops join
  • How to perform query operation on another query result
  • Identity column re-seed: when it is necessary?
  • MySQL -> Loop through a table, running a stored procedure on each entry
  • Optimize Postgresql query
  • How to speed up mysql query?
  • How to optimize a query for < operator
  • SQL Server transaction log [duplicate]
  • Can’t do a full backup because the log is full [duplicate]
  • Mysql error : Slave SQL Could not execute …on table

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding