permission problem

In sql server 2005, what is minimum right a user need to view the content of stored-procedures? That is, in SSMS the user will be able to right click a stored-procedure and then select "Modify" to view the content, but the user has no permission to promote it?

Thanks!

I don't understand what you mean by promote because there is no promote permission but most of what you need is covered in this thread below. Hope this helps.

http://forums.asp.net/thread/1492092.aspx

|||

I want to allow the users to able to view the content of stored-procedure, but they are not allowed to modify or create stored-procedures. What permission should I give to the user? It is easy in sql server 2000, but 2005 seems has different implementation. Thanks.

|||That is db_datareader permission but that is in the database your user also need the server login because there are two permissions in SQL Server, the server and the database. So go back to that thread for how to create it. Hope this helps.