Posted on 2001-09-07
We have to generate a report of who has what access to what tables in a database that contains confidential information. I have go it to the point of seeing what roles can see what obects by using sysobjects, sysusers and syspermissions. Now can I get it to show what access each of the roles have to the tables. I see the binary columns (seladd,selmod) in the syspermission tables but I can not select them because they just return null. Is there some way that I can get what I need out of SQL server?