I am looking for a script that will list windows userids and sql userids
with database object permissions.

Please help me with this task.

Thanks,

Hi

Look at the sysusers, syspermissions and sysprotects tables

John

Show quoteHide quote

Error converting data type nvarchar to int.
move records from table1 to table2 if does not exist in table3
Query Help
FIFO report
Performance Issues using Aggregate MAX function within a temp table