timscronin
MIS
ANyone know a way or a fairly cheap product which can audit when a structure changed in a database regardless of who changed it. Not a lot of changes anticipated, just trying to find problem
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Simple way to audit db structure changes
- Thread starter timscronin
- Start date
- Status
You need to remove access from people being able to makes changes to the structure if you are that worried about it. Data changes is one thing and somewhat normal but being worried about data structure is something else and easliy preventable. Just remove there ablity to update table structure.
I know of no such way because this isnt usually an issue.
I know of no such way because this isnt usually an issue.
- Thread starter
- #3
timscronin
MIS
Sorry not an option, Having to settle dispute between netowkr admins, slq dba's and webmaster
Network admins have no business being in there at all when a dba is available. set everyone up correctly who should have access then remove builtin/administrators. Webmaster may be a different issue, but if your haveing that many problems with people making changes and not admiting it, revoke there ability to make structal changes and have all scripts sent to the dba to run on the production database. You can leave them as datareaders/datawriters so they can modify the actual data. If thats an issue to, just give read only privlages.
It sounds like the sql dba needs to take sole control. I had to do that when i arrived here.Everyone bitched and moaned when i told our director of it we needed to do this. Everyone is happier in the long run. They know its well taken care of and only developers have acccess to thier own databases, no one else. IF it was changed it was either them or me. And i have no reason to change thier stuff. We do have a backup person with admin abilities, but they have no knowledge of sqlserver and know not to touch it. They are just there in case something needs to be done but im not around. The developers have to show them what they need to do. And he keeps a list of everything that he does for it to give to me in case they try to get sneaky.
If you are the dba, talk to your top IT/IS person and tell him the issues and what needs to be done.
It sounds like the sql dba needs to take sole control. I had to do that when i arrived here.Everyone bitched and moaned when i told our director of it we needed to do this. Everyone is happier in the long run. They know its well taken care of and only developers have acccess to thier own databases, no one else. IF it was changed it was either them or me. And i have no reason to change thier stuff. We do have a backup person with admin abilities, but they have no knowledge of sqlserver and know not to touch it. They are just there in case something needs to be done but im not around. The developers have to show them what they need to do. And he keeps a list of everything that he does for it to give to me in case they try to get sneaky.
If you are the dba, talk to your top IT/IS person and tell him the issues and what needs to be done.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question