Home Forums SQL Server 7,2000 T-SQL Stored procedures permissions RE: Stored procedures permissions
K. Brian Kelley
SSC Guru
Points: 114532
More actions
January 11, 2005 at 12:32 pm
#536890
At the DB level you can use sp_helprotect. Therefore, if you automate the tying of login to user, you should be able to script something to go through each database and report back.
K. Brian Kelley@kbriankelley