I have a database role that has a list of securibles such as stored procedures and tables. some for select, some for execute.
Is there a way that I can generate the lists instead of manually adding each one?
Like
grant execute to some stored procedures
grant select to some tables