Viewing SQL2005 Stored Procedure Code(DataReader)
We have a developer team that has been accustomed to viewing stored porcedure code through Enterprise Manager in SQL2000. We noticed that when having the same DataReader rights in SQL Management Studid(SQL2005) they cannot view the stored procedure code. Is this a bug in SQL2005 or is there another way/method(without maintenance nightmares) to allow them to view the stored procedure without giving them dbo permission.
Thanks in Advance,
Don Baker
Software/Hardware used:
Software/Hardware used:
ASKED:
January 5, 2007 4:47 PM
UPDATED:
January 8, 2007 3:21 PM
RELATED QUESTIONS
- Migrating stored procedures from SQL Server 2000 to 2005
- SQL 2005 Security to access 2 databases on same server via Stored Procedure
- Stored procedures to script table data in SQL Server 2005
- Calling stored procedure in a database to query data in another database
- a question about IMPORT/EXPORT from the SQL 2005 Migration
Answer Wiki:
I think you'll have to assign them the ddladmin role. If that's too much rights for them, you'll have to resort to granting the group explicit permissions ("View Definition") on those stored procedures.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
