Unanswered: Need information on syspermissions table
I have a MS Sqlserver 2000 database installed on my Windows NT4 PC.
After I granted permissions to a user for a specific table my Java code
(using JDBC - ODBC) was successfully able to retrieve the contents of the
table. However, when I examined the contents of the "syspermissions" table
using the following command :
osql /U sa /P /d %1 /w 256 -Q "select grantee,grantor,actadd,actmod,
from sysobjects where sysobjects.id = syspermissions.id) 'objname'
from syspermissions,sysobjects where
(sysobjects.xtype = 'U' and sysobjects.id = syspermissions.id) order by objname"
I did not see any difference in the entry for the table to which I granted
According to the documentation I have read the "syspermissions" table is the
place where access rights information is stored.
Am I missing something ? Where is the info on granted access rights stored
if not in the "syspermissions" table ?