Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Location
    Bangalore
    Posts
    28

    Unanswered: Review host system privilages assigned to DBA account

    Hi,

    Is there a way to check if the SQL Server windows login with sysadmin previlages have other host system (windows 2003) previages on the system...? Is there a way to use TSQL to find this?
    or
    what are the other options avaliable to verify this??

    Thanks
    Cheriyan

  2. #2
    Join Date
    Aug 2005
    Posts
    75
    I'm not aware of anything native (I don't think there is), but if you have powershell installed and have xp_cmdshell enabled, you could use tsql to execute a powershell script to query local group membership.

    PowerShell Code Repository - Find Local Group Members

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •