PDA

Click to See Complete Forum and Search --> : sp_helprotect

sriranjani
November 26th, 2003, 05:43 AM
does the command...

EXEC sp_helprotect NULL, 'dbo'

display the user dbo's permission list??
or..how should i change the above syntax so that the user permissions are displayed??
is there any other stored procedure that doesthis job?
dinesh123
November 26th, 2003, 06:24 AM
from BOL

sp_helprotect
Returns a report with information about user permissions for an object, or statement permissions, in the current database.