stored procedure with a lock

  • 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?

  • Not sure what you mean? Can you run the proc from SSMS/SQLCMD?

  • The little picture of the padlock , by the stored proc name on the tab, means that the procedure is read-only

  • 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

  • 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