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

Category: Security

Restrict access to a new schema to a specific role despite users having db_datareader?

By adminPosted on March 15, 2023

Question : I’m working in a SQL Server 2016 database that is not of my design nor can I fundamentally […]

SQL Server 2012 Error 9512 when modifying user login

By adminPosted on March 15, 2023

Question : We are attempting to grant access to a database to one of our employees. We open up his […]

Oracle Database Security – Audit Trail for specific user and specific module application

By adminPosted on March 12, 2023

Question : I want to enable audit trail for specific user, but only for sessions when this user connect to […]

How secure is a linked server in SQL Server

By adminPosted on March 10, 2023

Question : I am in a situation in which I should doubt everyone (even my developer team and database admin) […]

Security Risks with having Test Stored Procedures that have SQL Injection Vulnerability

By adminPosted on March 9, 2023

Question : I noticed that some of the stored procedures used in our integration tests for data generation have SQL […]

Is the Advanced Security Pack required for windows authenticaion?

By adminPosted on March 8, 2023

Question : Can anyone tell me if the Oracle Advanced Security Pack is required for single sign in under Windows? […]

How do I copy SQL Server Data Discovery and Classification rules and suppressed recommendations to another database?

By adminPosted on March 5, 2023

Question : We have hundreds of SQL Server databases, all of which share a common schema. We are implementing Data […]

Access Control not logging successful logins on MongoDB 3.4 Community

By adminPosted on March 4, 2023

Question : After adjust the verbosity of the parameter “accessControl” with the command: db.setLogLevel(5,”accessControl”) The log file still not login […]

Data Factory keeps getting “untrusted connection” error when logging into on prem SQL Server via IR on VM

By adminPosted on March 4, 2023

Question : We have: A local SQL Server database A VM with the Integration Runtime installed on it A Data […]

How to implement UNIX like ACL for table rows

By adminPosted on February 28, 2023

Question : EDIT: I can’t create or use native MySQL users. I have to use users stored in table with […]

  • 1
  • 2
  • 3
  • 4
  • …
  • 87

Recent Posts

  • InnoDB engine is not loading after tuning parameters
  • How to optimize query on MYSQL with multiple group by clause
  • Referencing database programmatically via T-SQL
  • How to set roles and users with correct permissions on Postgres? [closed]
  • SQL query optmization [closed]
  • Is it possible to optimize this query? Currently taking days (no sign of stopping) on ~11 million records
  • We use MongoDB 3.6 community version, How can i get the number of hits on single collection as well as bandwith usage?
  • Will too many tables slow Mysql down?
  • Group By hour over large dataset
  • “Force Encryption” vs “Force Protocol Encryption” in SQL Server
  • Mysql checksum for master-slave replication returning different values, despite being identical
  • Same record shows up multiple times in ordered paginated query
  • Allow users to only view the databases they have access to
  • Does ALTER on PostgreSQL, Oracle table (respectively) create intermediate copy of the table?
  • Delete rows from a large table with joins and aggregating (resulting in 1 % less rows in the big table)
  • How to record sqlplus session activity like “/var/messages” in Unix..? [closed]
  • Mysql dump with View dependent on user
  • How does Oracle know who I am?
  • Filter a SQL replication
  • Return values from Left Table Only Once

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