October 3, 2014 at 6:50 am
Hi
I work in a world of PCI and change control as as such we need a distinction between prod and dev
At the moment the permissions of dev are locked down to such an extent that on the Prod system they cannot
view Sprocs, jobs ect
My question is: what is the best way of giving devs access to be able to view all sproc, index, PK, FK definitions and jobs ect, basically being able to view everything without being able to actually modify anything?
Is there a simple way of doing this?
Cheers
Andy
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
October 3, 2014 at 11:38 am
I'd recommend a database project for each database that includes agent jobs that apply to that database. Then you can have all of this in Source Control as well.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply