Blog
-
Betting on SQL Injection [T-SQL Tuesday #51 – Place Your Bets]
SQL Injection is the most commonly exploited vulnerability. Don’t bet that it wont happen to you. Read on to see recent cases of prominence and learn why you can’t ignore it.
-
DENY vs. REVOKE – Part 3 – Hierarchies of Securables
DENY can be used to fine tune permission management in hierarchies of securables. A common securable hierarchy is table, schema, database, server. Read on to see how a DENY on one level of such a hierarchy can override a GRANT on another level.
-
DENY vs. REVOKE – Part 2 – Hierarchies of Principals
REVOKE and DENY are similar at first glance. However, DENY can be very powerful when used in the context of security principal hierarchies. Read on to get all the details.
-
DENY vs. REVOKE – Part 1 – Are they just synonyms?
DENY and REVOKE look very similar, they might just be the same. And indeed, when looking at a single security principal and a single securable in isolation that are functionally identical. But there is more to it. Discover their similarities and differences in this five-part series.
-
REVOKE CASCADE does not work on CONTROL permission
REVOKE together with the CASCADE keyword removes a permission and also all child permissions that were granted based on it. Read on to see how this plays out if the permission in question is the CONTROL privilege.
-
REVOKE CASCADE: Revoking an Entire Grant Hierarchy
Does the CASCADE keyword on the REVOKE statement imply that you can build an entire hierarchy of grantable grants using GRANT … WITH GRANT OPTION? What does that mean for your permission management plan? Find out now.
-
How to REVOKE just the GRANT OPTION
To remove just the grant option from a permission that has been granted specifying WITH GRANT OPTION , the REVOKE GRANT OPTION statement can be used. Read on to get all the details.
-
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.
-
Security Pitfalls – Revoking Column Permissions
A REVOKE always removes only an exactly alike GRANT. However there is one important exception: The handling of column permissions follows its own rules. Read on to get all the details.
-
REVOKE: How to Undo Granted Permissions
If you have a security principal with a specific permission and you want to remove that permission from that principal, you can use the REVOKE statement. Read on to get all the details on how to use it.
We can get a database clean and know how to keep it that way. We’ll help you 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
