February 11, 2010 at 9:47 am
we have 2 DBA's support the servers for our BI environment, and we also have BI developers that have almost full rights to the BI environment as well. Problem is that they are always updating reports or BI data in the middle of the day and this causes issues where people can't view reports.
other than the management issues of segregating control we're looking for a short term alternative of auditing the environment. we're looking to set up database DDL triggers on the BI databases to alert us of any changes to stored procedures in the daytime. Next step is we want to audit the SSRS environment to alert us when anyone makes changes to a report.
is there any easy way to do this?
February 11, 2010 at 10:04 am
Can't you set up source control and a check-out/in process for the reports? That's even better than just auditing, and not hard to set up.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 11, 2010 at 10:34 am
something like VS Studio Team Edition? from what i know the devs use the ancient Visual Source Safe or something like that
February 12, 2010 at 5:57 am
The team version is best, but Visual Source Safe would probably work.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply