-1

I am a DBA on many servers running SQL Server and am a big user of sp_Blitz. The issue I have is that I am still to maintain a database that is migrating to a VM on AWS.

The issue is that I'm not permitted DBA access. I can only now connect with user credentials.

But I still have desire to monitor as much as possible. Even simple stuff like check the backups have been run. So I can now only run minimal queries. Obviously I can't install sp_Blitz as it creates stored procedures.

But I do have full DBO to the database before it migrates over. Yes I can install sp_Blitz in that database, as it would be dbo.sp_Blitz. But I won't have the permission to then run it as a user.

Any suggestions or pointers on how I can get it (or open to alternatives) into the database in a way that I can execute when I'm just a user?

1

2 Answers 2

2

sp_Blitz is really for database administrators, not users. If you don't have DBA permissions, sp_Blitz won't be a good fit.

If you want to skip specific checks that you don't have permission for, you can use the SkipChecks feature described in the documentation, but if you're not a DBA, you're probably going to have to do a lot of skipping just to get it to run.

0

If you can get someone else who is a sysadmin to recreate/modify the sp_blitz stored procedures they could add execute as "blah" to the stored procedure definition and then grant you exec permission to the SP. When you run the sp_blitz sp it would then execute in the context of the specified user (replace blah with something sensible) who presumably does have the right permissions and return you the normal results.

For more details you could look at Books on Line or this article https://www.mssqltips.com/sqlservertip/1227/sql-server-execute-as/

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.