Tag: REVOKE CASCADE
-
How to REVOKE a GRANT … WITH GRANT OPTION
When revoking a permission that was granted with the WITH GRANT OPTION, you cannot just revoke the privilege itself. Instead SQL Server forces us to remove all permissions that were granted based on it too. Read on to see how this might impact your permission management.
We know to keep a database secure. We’ll help you to do the same.
From the sqlity.net blog
-
How to identify the SQL Server Service Account in T-SQL
-
How to Change a SQL Login’s Password
-
Hash Algorithms – How does SQL Server store Passwords?
-
How to Re-Create a Login with only a Hashed Password
-
B+Trees – How SQL Server Indexes are Stored on Disk
-
The Hidden SQL Server Gem: UPDATE from SELECT
-
A Join A Day – Nested Joins
-
Determine the Uptime of a SQL Server Instance
-
A Join A Day – The Left Anti Semi Join
-
Log Reuse Waits Explained: LOG_BACKUP
