AccessSQLUser
Programmer
Is there a way to show all objects that a specific role has permissions for?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Object Permissions
- Thread starter AccessSQLUser
- Start date
- Status
tlbroadbent
MIS
Use sp_helprotect. Read about all the options in SQL Books Online.
This example lists all permissions that user Judy has in the current database.
EXEC sp_helprotect NULL, 'Judy'
Terry
;-) He has the right to criticize who has the heart to help. -Abraham Lincoln
SQL Article links:
This example lists all permissions that user Judy has in the current database.
EXEC sp_helprotect NULL, 'Judy'
Terry
;-) He has the right to criticize who has the heart to help. -Abraham Lincoln
SQL Article links:
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question