SQLjobvis is a tool I’ve blogged about before. For more info on what SQLjobvis is and how it can help you you can read my blog post here. A reader had commented on that post and mentioned that they didn’t have the necessary permissions to run SQLjobvis. But what are those permissions? The website doesn’t appear to
Continue reading Permissions required for SQLjobvis
In order to execute queries under a different security context (such as another login) using the EXECUTE AS clause, you must be able to impersonate the user. To grant impersonate permissions on a specific login, run the query below. To test this works you can run the query below.
A user will usually receive this error message when trying to execute xp_cmdshell and does not have sufficient permissions. To grant permissions to execute xp_cmdshell using TSQL, run the query below. To test this works I usually run the query below. To test the granted execute permissions work for the intended user, I impersonate them
Continue reading The EXECUTE permission was denied on the object ‘xp_cmdshell’, database ‘mssqlsystemresource’, schema ‘sys’
Redgate SQL Source Control is a SSMS plug-in which allows you to source control your database schema. Assuming you or your users have limited access, some permissions are required to use this application. At a database scope the VIEW DEFINITION permission is required to view code changes which have not been committed. ALTER is also
Continue reading Permissions required for Redgate SQL Source Control