Select Permissions on Password in syslogins

• Stacey

  SSCommitted

  Points: 1766

  More actions

  May 28, 2008 at 11:49 am

  #94196

  Okay we have this product that is suppose to monitor databases for changes. One of the changes is on the password column in syslogins. The vendor says that their application login must be SA. I do not grant SA to anything.

  Problem is I have not been able to find a way to get the select on the password column to work. "SELECT permission denied on column 'password' of object 'syslogins', database 'master', owner 'dbo'"

  The product is called TripWire. SQL Server 2000 sp4

  Any suggestions would be great. Mean while I will keep trying. :hehe:

  
  Stacey W. A. Gregerson
  

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  June 2, 2008 at 12:53 pm

  #823215

  To update anything on a system table, we need to run

  sp_configure 'allow updates', 1

  RECONFIGURE WITH OVERRIDE

  After completion, we need to run

  sp_configure 'allow updates', 0

  RECONFIGURE WITH OVERRIDE

  May it help.