|
Run the following SQL to find permissions granted on users on the database select case when p.protecttype = 205 then… READ MORE
|
Run the following SQL to find permissions granted on individual objects on the database select case when p.protecttype = 205… READ MORE
|
— print usernames and the roles assigned to the user, it can be run against any database and it will… READ MORE
|
DECLARE @role_name VARCHAR(100) DECLARE @member_name VARCHAR(100) DECLARE @rolescur CURSOR DECLARE @rolememberscur CURSOR DECLARE @loginname VARCHAR(100) DECLARE @username VARCHAR(100) DECLARE @logincur… READ MORE
“Control what I can control”
~ Alex Lima