October 10, 2007 at 8:55 am
I have created a role and gave that role access to create, execute SP's within the DBO schema. The one permission I am missing is when they create their procedures, they are not allowed to grant execute on that procedure to others.
This is the permissions they currently have
GRANT ALTER ON SCHEMA::dbo TO
GRANT CREATE PROCEDURE TO WITH GRANT OPTION
GRANT SELECT, INSERT, UPDATE, DELETE ON SCHEMA::dbo TO
GO
When they issue "GRANT EXECUTE ON dbo. " right after creating the procedure in the DBO schema they get the following message.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object , because it does not exist or you do not have permission.
October 10, 2007 at 8:58 am
GRANT EXECUTE ON SCHEMA::dbo TO someuser
use SCHEMA to disambiguate
Andras
October 10, 2007 at 9:01 am
But doesn't that just gice them the permission to execute the procedure? What I am looking for is for them to be able to issue a GRANT EXECUTE statement on a procedure that exists in the DBO schema
October 10, 2007 at 9:08 am
Sorry, I misunderstood you. You could either give them CONTROL, or use the grant EXECUTE statement with "WITH GRANT OPTION".
Andras
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply