Permissions

Question

Post reply

Permissions

Mike Levan

SSChampion

Points: 14201
More actions
August 24, 2005 at 7:51 am

#90792

HI
We are getting the following error when one of my developer trying to change a stored procedure though I have checked permissions for creating procedure in my database properties.
-------------------------------------------------------------------------------------------
Error 3704: User does not have permission to perform this operation on procedure selchar
--------------------------------------------------------------------------------------------
any Help?

Viewing 13 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

Does he own the proc. Is he at least in the ddl_admin group? Is the proc qualified with the owner?

Mike Levan SSChampion Points: 14201 More actions · Answer 2

He does not own the SP, I myself created SP and granted him all permissions tfor SP

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

Is he at least in the ddl_admin group?

Is the proc qualified with the owner in the script?

Mike Levan SSChampion Points: 14201 More actions · Answer 4

If u dont mind, can u pls let me know how can I check that?

Mike Levan SSChampion Points: 14201 More actions · Answer 5

I have a fixed server role and added that user account to this role. and this role was set to have all the permissions to create a SP, But the User is unable to do it.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 6

I'm not the security expert here... I'll let someone else pick this one up.

Mike Levan SSChampion Points: 14201 More actions · Answer 7

Mike Levan

SSChampion

Points: 14201

August 24, 2005 at 9:16 am

#584644

Sure..Thanks for ur participation.

Greg Charles SSC-Forever Points: 45403 More actions · Answer 8

ALTER PROCEDURE permissions are not transferrable, according to BoL. See "Alter procedure" in BoL.

I suggest, as Remi was getting at, that you add the user to the fixed database role db_ddladmin. It has all DDL permissions in a database, including ALTER PROCEDURE.

Greg

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 9

Glad to see I'm not completly clusless in that departement .

Mike Levan SSChampion Points: 14201 More actions · Answer 10

I added the role to db_ddladmin, now its working.

Thanks a lot Greg.

Mike Levan SSChampion Points: 14201 More actions · Answer 11

I have added role to db_ddladmin, now its working fine.

Thanks a lot Greg

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 12

Just for further referrences, what wasn't clear about that question?

Is he at least in the ddl_admin group?