Tag: Permissions
-
Checking what permissions they have in SQL Server
The function sys.fn_my_permissions is very useful for seeing what permissions you have, but it can be just as useful to check someone else. For this all that is needed is to use EXECUTE AS to impersonate them.
-
SQL Server Instance Security: Scripting Permissions Part 2
After writing a powershell way of scripting permissions I thought I better just show the way I used to do it using T-SQL. Although this script is not complete and is kind of relic of my scripting work I thought that I would include it and perhaps maybe if it is on this blog it…
-
SQL Server Instance Security: Scripting Permissions
Another How-To post and this time focusing on scripting permissions. Here is how to script User(s), Object(s), Role(s), Server Role(s) and Server Object(s) Permissions. Beginning with the simple way via SSMS, before showing a custom script solution that I have written. Scripting SQL Server Security: Simple Solution In order to script the security settings for…