Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlpal2007
Posting Yak Master
200 Posts |
 Posted - 2012-02-02 : 09:47:59
|
| Hello All,How do I grant permissions to view definations of stored procedures, views, functions, triggers etc...? In SQL 2008 lot more permissions are added. Can someone please point me to the correct one instead writing a few lines of SQL code and then granting permissions?Thanks, |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-02-02 : 15:14:54
|
| GRANT VIEW DEFINITION TO [user]; |
 |
|
|
|
|
|
Grant permissions to certain object types at once