This script cycles through a chosen selection of databases, and grants permissions to all tables, views and stored procedures to a user or role.
To use, change the ###text### to control which databases, permissions and the user/role concerned.
Like the one posted before, the use of the SP is like this: proc_alerts 1,18. This will show the first 18 alerts on the system. OR proc_alerts 20,35 will show from 20 to 35. This lets you manage the list without letting go out of the screen.