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

Tag: logon

Safe and secure implementation of logon trigger in SQL Server 2014 Express edition?

By adminPosted on November 8, 2021

Question : I’ve to implement the following requirement: Access to SQL Server instance shall be allowed only from a C# […]

Lockdown database access on certain tables

By adminPosted on May 19, 2021

Question : I have a dev team who have a number of SQL databases used as a back end for […]

Lockdown database access on certain tables

By adminPosted on January 29, 2021

Question : I have a dev team who have a number of SQL databases used as a back end for […]

failed logon trigger blocking access into SQL Server instance

By adminPosted on January 22, 2021

Question : I wanted to create a trigger to record all the names of logins(who logon into system) in ServerLogonRecords […]

Recent Posts

  • Bidirectional data transfer
  • Update statement errors, parenthesis, failed validation ORACLE
  • postgresql grant user privilages to dynamically created tables
  • How can streaming replication be kept lagged by a certain ‘delay’ time?
  • Query for similar syllables on a field
  • Write filename, servername/IP and date+time in spool file
  • Designing a table with multiple null FKs
  • I am trying to get the string between hyphen (-) which is before (+) upto next colon (:)
  • Why would a SELECT INTO cause an arithmetic overflow?
  • Possibility to implement time to execute / TempDB usage restrictions on some role groups in SQL Server?
  • Login failed for user – Error 18456 – Severity 14, State 38
  • comparing two values in same column with another column using AND condition
  • Slow running aggregate of aggregate query
  • Is it possible to get seek based parallel plan for distinct/group by?
  • PostgreSQL replication: out-of-sequence timeline ID, when former master made slave
  • Autogrowth Analysis in PROD DB based on the trace file data
  • Single versus Multiple databases
  • Does a user who has permissions to select from a view also need select granted to the children entities of that view?
  • Parse a string to find data between delimiters, multiple occurrences
  • Oracle multiple databases on same server [closed]

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