Acess on Production Server

Hi,

Presently our Organisation is in process of Implementing SOX.

Under Compliance all the User have to be removed from the Production Server.

1.My Question is Do a DBA Should have Admin Privilages on the Production Server.

If yes then what are the Actitvies that a DBA has to perform only if DBA have admin privilages.

Regards

Sufian

I don't know the SOX 'rules' about this but I would not want to be responsible for a production machine without having admin privileges on the server.

But that is a personal opinion, the Books Online contain information about which privileges are required for which actions. I will let you be the judge of whether you need sysadmin rights or not ;-)

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

|||

These sources will better prepare you to make the appropriate decisions about security accounts and the local server/SQL Server/ and/or domain accounts.

Configuration -Service Accounts, SQL Server 2005 - Setting Up Windows Service Accounts
http://msdn2.microsoft.com/en-us/library/ms143691.aspx
http://msdn2.microsoft.com/en-us/library/ms143504.aspx

Configuration -Service Accounts, SQL Server or SQL Server Agent service account
http://support.microsoft.com/kb/283811/en-us
http://msdn2.microsoft.com/en-us/library/ms143691.aspx

Configuration -Service Accounts,Selecting an Account for the SQL Server Agent Service
http://msdn2.microsoft.com/en-us/library/ms191543.aspx
http://support.microsoft.com/kb/907557