stored procedure | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

stored procedure

we migrated from sqlserver 2000 to sql 2005, we have developers able to view the stored procedures in sqlserver 2000,but once we migrated, they are not able to view the stored procedures.. i am not sure why is this…. we have tp provide then db_owner in order to view the procs in sql 2005… is there any idea how can i resolve this… thanks
When you said "not able to view", what they are using to view sp?
Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided “AS IS” with no warranties for accuracy.
no they are not using any thing to view that. The stored procedures are not visible to them..
do they need any special permission to view those?? thanks

Management Studio –> Databases –> YourDataBase –> Programmability –> Stores Procedures (pick one) –> Properties –> Permissions. Check if developers (or some database role) are there. Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided “AS IS” with no warranties for accuracy.
i figured out that , i need to add them either as ddl_admin or dbo_owner in order to view the stored procedure thanks
Refer to thishttp://www.microsoft.com/technet/te…echnet/technetmag/issues/2005/05/DataSecurity paper and view thru Execute context. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>