July 19, 2011 at 11:36 pm
Dear SQL-Friends
I have completed my project now my company want me to go through the application again and make neccessary auditing from starting
Like
1.Performance wise
2.Query Wise
3.Admin wise
4.Security Wise
I need to check each section neatly and pin point the neccassry changes what can b replace,for this i need a checklist for each department from the above list where/what i have to be careful in each section.
Thanking in advance
and waiting for your valueable comments.
Thanks
Syed Sami Ur Rehman
Creative Technosoft System | http://www.cts-in.com
Syed Sami Ur Rehman
SQL-DBA
Creative Technosoft System | www.cts-in.com
July 19, 2011 at 11:54 pm
Hi,
While the SQL Server security model has many enhancements, it also adds the extra layer of permissions that we must monitor to make sure no one has been given more access than they need or that they’ve already circumvented security to elevate themselves. There's also the spectre of user's who have changed roles within the company but the SQL Server permissions structure has not been adjusted. This goes back to assigning object access to groups and not individuals.....
July 20, 2011 at 12:23 am
Thanks patel
Looking forward for more information
Syed Sami Ur Rehman
SQL-DBA
Creative Technosoft System | www.cts-in.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply