Script roles 1

[woyler]

Hi all,
Is there a way to generate a script from existing user roles that will include all permissions that role carries?
i.e.
grant execute on <table1> to <role>
grant execute on <table2> to <role>
etc.

thanks in advance.
Bill

 

[mrdenny]

This thread thread962-1324602 covers how to get the needed grant statements.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[woyler]

Thank you Denny.

 

[mrdenny]

No problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com