I am using sql server 2005. When i create a login as public, the login is not able to see sql stored procedures in SSMS by default.
If I create a role and grant execute permisison to the role and assign this role to the login then they can view the stored procedures. Do we need to have execute permission to view the procedure?..what role do i need to use against the loging to make them
to view the stored procedure.
What I am missing?
Best regards, Sengwa
View Complete Post