Stored Procedure Permissions
Posted on 2004-08-05
This is my first time creating a stored procedure. I basically copied another and tweaked it to my needs. What I found however is that I didn't set the permissions on it so therefore my ASP page produces this error when I try to submit the form data to the database:
EXECUTE permission denied on object 'sp_myprocedurename, database 'Test', owner 'dbo'
I am not sure what type of access is setup. I am very familiar with creating logins in SQL Server EM but not sure if we're really using that type of authentification...or even if I do create a login, I don't even see a list of stored procedures, just the ability to give dbowner rights and such to databases.