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

Tag: users

How to get user-specific settings in PostgreSQL?

By adminPosted on March 5, 2023

Question : I have to collect some information of PostgreSQL roles. One piece of information is whether the role has […]

How to set statement timeout per user?

By adminPosted on March 2, 2023

Question : I have multiple users in Postgres. I would like to set up different statement timeouts for different users. […]

how to join table from different database with different Users of database?

By adminPosted on March 2, 2023

Question : I have Two database called. Database1: host: 127.0.0.1 user: root1 pass: root1 dbname: db1 Table 1: Category ID […]

Postgres 10. Hide users/roles from other users

By adminPosted on February 23, 2023

Question : I have a postgresql 10 installed and I want to hide the name of users/roles to other users. […]

User and login mapping after an SQL Server restore

By adminPosted on February 23, 2023

Question : I need to restore a DB from an SQL Server instance to another and I am well aware […]

What are possible ways of handling multiple users accessing the same database via custom web API? [closed]

By adminPosted on February 16, 2023

Question : Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the […]

When should I reference the User record or User Profile record

By adminPosted on February 14, 2023

Question : I know it is a common paradigm to separate tables when building a User profile. For example, having […]

Database level access in Azure SQL managed instance

By adminPosted on February 14, 2023

Question : In my Azure SQL managed instance I have two databases, Database_A and Database_B. User A_ABC has access only […]

Getting User Access in Individual Databases MSSQL

By adminPosted on February 11, 2023

Question : So, here is the scenario. I need to give user access on multiple databases ( but not all […]

mysql user host field in slow query log

By adminPosted on February 7, 2023

Question : Mysql shows the following value in the slow query log # User@Host: user[user] @ [127.0.0.1] I’m assuming one […]

  • 1
  • 2
  • 3
  • …
  • 25

Recent Posts

  • High availability primary does not automatically take secondary role when back online
  • How should I set up these tables in my relational database?
  • Query table based on column value
  • MySQL – admin user is able to change password of the super user
  • ORA-02049 and ORA-02063 Errors
  • Postgresql responses are slow without internet
  • How To Strip Hebrew Accent Marks
  • How to get paged resultset from a table?
  • In slow_log tables, sql_text column showing “throttle: index not used’ warning(s) suppressed” instead of exact query
  • Is a Named Instance more Secure than the Default Instance?
  • Why is SQL Server 2014 consuming so much RAM with no active data stored?
  • Why are collations specified at the column level?
  • Why does mysql give different result for this summations? [duplicate]
  • SQL Server Replication tools [closed]
  • Restructuring table – start with PK or not?
  • SQL Express bottlenecks
  • Find the size of each index in a MySQL table
  • MongoDB multi update consistency
  • Postgres full text search with unaccent and inflection (conjugation, etc.)
  • If my Data, Log and Tempdb drives are on the same LUN, are they using 1 physical drive?

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