June 25, 2008 at 1:16 pm
My app runs a stored procedure that eventually times out. In SSMS the proc has a picture of a lock on it when logged in as that user. I've never seen that before. Is it a permissions issue?
June 25, 2008 at 2:08 pm
Not sure what you mean? Can you run the proc from SSMS/SQLCMD?
June 26, 2008 at 7:59 am
The little picture of the padlock , by the stored proc name on the tab, means that the procedure is read-only
September 29, 2011 at 8:12 am
i am facing the same issue, i want to give user to read the procedure but there is lock(picture) on the stored procedure. I had given the user read and write permission but the lock is not removed.
When i givethe user the owner permission the lock is removed
there is no stored procedure with encyption
please help
October 1, 2011 at 11:02 pm
Grant the user VIEW DEFINITION on the object. This will allow the user to view the procedure text, as long as the procedure isn't encrypted.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply