Cannot execute store procedures
-
i have a user that has been granted database roles as db_datareader, db_datawriter, db_ddladmin. but when he tries to run or modify the store procedures in the database he cannot. I don't know what might be the ssue. please help if any idea.
-
this is an urgent issue friends. please help me out.
-
does he have execute permission on the procedure? He needs that, and control permission to modify it.
The probability of survival is inversely proportional to the angle of arrival.
-
-
how do i do that, let me now please.....i need some steps
-
The definition of those Database Roles in BOL will make it clear as to why the permissions you require have not been granted.
-
ho do i
does he have execute permission on the procedure? He needs that, and control permission to modify it.
-
http://msdn.microsoft.com/en-us/library/ms345484.aspx
Hope that helps.
-
but Chim, i want to grant on all the stored procedures. and by that process i can grant only one by one stored procedures.
-
I will advice you to Google a little before asking. It will help you a lot better! good luck.
-
espanolanthony (9/23/2009)
but Chim, i want to grant on all the stored procedures. and by that process i can grant only one by one stored procedures.You can grant execute to a schema. Let's assume for sake of argument that all the procedures are owned by 'dbo' (not the right way to build your system, but it's pretty common). You can grant execute to all procedures this way:
GRANT EXECUTE ON ROLE::[dbo] TO [someuser]"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
You state that you have given these rights to the user.. "db_datareader, db_datawriter, db_ddladmin". That should automatically give permission for executing the user defined stored procs. But are you sure you gave the rights for the right schema/Database?
Or am I wrong?
-Roy
-
Roy Ernest (9/24/2009)
You state that you have given these rights to the user.. "db_datareader, db_datawriter, db_ddladmin". That should automatically give permission for executing the user defined stored procs. But are you sure you gave the rights for the right schema/Database?Or am I wrong?
Unless the user is mapped to the schema, they won't automatically get execute privileges for that schema unless you grant them.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Thats what I thought. I guess the rights were not mapped to the right Schema. 🙂 Thanks for clarifying. 🙂
-Roy
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply