User Managment in SQL Server 2008

View previous topic View next topic Go down

User Managment in SQL Server 2008

Post  Pankaj on Fri Nov 18, 2011 5:22 pm

HOW TO BUILD THE POWERFUL USER MANAGEMENT IN MSSQL 2008 FOR THE DATABASE SECURITY PURPOSES ?

Pankaj
Guest


Back to top Go down

Re: User Managment in SQL Server 2008

Post  Jugal on Fri Nov 18, 2011 5:28 pm

Hi Pankaj,

I am not getting your question. If possible, please add more information here.

For user management you can do one of the following.
--> Enable the C2 trace auditing for the user activity
--> You can run the profiler trace as well
--> You can setup the policy based management to prevent user for particular rights
--> Make ITIL practice in place, which records RFC
--> Document the Permission
--> Use SP help revlogin procedure for the login backup
--> Setup the auditing
--> Use third party tool, like compliance manager

Let me know if this information will be helpful to you...

Jugal
Guest


Back to top Go down

View previous topic View next topic Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum