Monday, March 12, 2012

permissions for SQL admin

Hi,
I got a challenging question from my DBA: he set up some auditing
procedure to check all the user computers to see the versions of small
applications. This is done through a Storeprocedure under one DB called
auditing. Basically, he said when this storeprocedure runs, the script runs
and get all the version information from user boxes. And, as he said, this
needs domain admin rights to run because this script actaully grabs
information from all user computers.
Please advice what is the best, suitable rights rather than domain admin
rights in order for this undertaking to be carried out.
Thanks.If you want to run that procedure on a schedule you will have to grant
the SQL Agent account the appropiate permissions. If you want to run
that ad-hoc, you will have to make sure that the current user, if the
authenticated with WIndows authentication, is priviledged to the
operations on the client, if the user is authenticated with SQL Server
authentication that the SQL Server service account is priviledged to
run the operations on the client.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
--

No comments:

Post a Comment