User profile for pholden

Thanks Russell, I understand, would be great to get the opinion of one of your DBAs. / comments

Thanks Russell, I understand, would be great to get the opinion of one of your DBAs.

0 votes

Hi Russell, Thanks for the response. Maybe it's me but would you like to expand on "for obvious reasons". Given the lack of queries around setting up permissions for SQL Monitor I can only think that most?/many? sites are running it with the account in the sysadmin role which suggests to me that they don't much care what it does as long as it works? Surely it would be better to educate DBAs into having properly locked down schema objects, in their own databases if appropriate, than to misuse(?) existing schema objects and thereby introduce workarounds to security best practice? Possibly this is out of scope of this thread now, or I'm talking a load of rubbish as I am reasonably new to a role that requires me to secure SQL Server, but I'd be interested to get your thoughts on this. Regards, Paul / comments

Hi Russell, Thanks for the response. Maybe it's me but would you like to expand on "for obvious reasons". Given the lack of queries around setting up permissions for SQL Monitor I can only think th...

0 votes

Thanks Alex, we have taken the GRANT EXECUTE ON approach. / comments

Thanks Alex, we have taken the GRANT EXECUTE ON approach.

0 votes

SRP-11129 - Use xp_readerrorlog to read error log - does this require additional permissions

Hi, We have set up a login for SQL Monitor as per the instructions in the documentation here:https://documentation.red-gate.com/sm7/getting-started/requirements/permissions However we are getting t...

2 followers 2 comments 0 votes

Wouldn't the correct way to do this be to add your own database to the instance? / comments

Wouldn't the correct way to do this be to add your own database to the instance?

0 votes

How can we help you today?

pholden

Activity overview