ADSM-L

TDP for SQL: does the id absolutely require SA priv?

2005-08-25 08:26:17
Subject: TDP for SQL: does the id absolutely require SA priv?
From: Steve Schaub <Steve_Schaub AT BCBST DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 25 Aug 2005 08:26:02 -0400
TSM serv = 5.2.2.0
TSM TDP = 5.2.1.0

I'll spare you the political details, but our SQL Server admin is claiming
that NIST standard required him to remove SQL access from the SYSTEM
account.  We created a specific AD id and have been testing, but he wants to
not grant this id SA priv, for the same reason.

What is the minimum amount of priv an id needs to run TDP backups?  The TDP
doc "seems" to assume SA priv, but is it absolutely required?  The admin
would be running any restores from the gui under his own id.

thanks.

Steve Schaub
Systems Engineer, WNI
BlueCross BlueShield of Tennessee
423-752-6574 (desk)
423-785-7347 (cell)

Please see the following link for the BlueCross BlueShield of Tennessee E-mail
disclaimer:  http://www.bcbst.com/email_disclaimer.shtm

<Prev in Thread] Current Thread [Next in Thread>