Difference between sysprotects and syspermissions?

• Ben Fidge

  SSC Eights!

  Points: 832

  More actions

  April 4, 2004 at 5:07 am

  #152104

  What is the difference between sysprotects and syspermissions tables?

  Ben

• April 7, 2004 at 8:00 am

  This was removed by the editor as SPAM

• Mike Good

  SSCertifiable

  Points: 7415

  More actions

  April 8, 2004 at 9:43 pm

  #502249

  from http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops3.mspx

  sysprotects is a "dynamically created psuedo-table" while syspermissions is a real table.  Perhaps it is THE real table underlying sysprotects?