asked
db owner unable to access stored procedures
Using SSMS 2016 sa user can't see stored procedures in a database. (can see all sys stored procedures) I am logged in as db owner; I can see them, but I can't execute them. I get this message: > Msg 2812, Level 16, State 62, Line 1 > Could not find stored procedure > 'GetConvRows'. If I right-click on the procedure in the object explorer, I can execute it.
***SEE COMMENTS BELOW*** You may need to give yourself permissions to execute stored procedures. You will have to create the role first though. CREATE ROLE sp_execute GRANT EXECUTE TO sp_execute Then grant yourself the sp_execute role for that particular database.
I believe this should not have been marked as the accepted answer as it could lead the future users down the wrong path. At least an edit to the answer is required as the users might not read the comments carefully. The actual problem seems to be no mentioning of the schema name while executing the procedure.
Thank You!. very direct to the point. That of course worked. I had assumed my ownership of the database would make it so, but after studying up on it. I see why now.
can either of you recommend a good source for gaining a full understanding of rights and priviledges in the new SQL Server environment? My experience is way too old. Sybase in the 1990's
I think that I'd start here:
http://www.sqlservercentral.com/stairway/110890/. It should be a good stairway series on SQL Server security and will get you started.
18 People are following this question.
