Recent content by hydrorocks

That won't work, it only would work if I give hin the db_owner role which is to much power for the user. I already gave him execute permission on this procedure. What I need is to give him the db_owner role for just this one procedure... I think this is too hard to explain... I don't get it...

Hi, I want a User that he can execute a procedure with db_owner rights. The user does not have the role db_owner, but he needs it for this procedure to work. So I tried this: GRANT Execute ON myProcedure to myUserName as db_owner But I get "Grantor does not have GRANT permission." back. What...

Hi, Thanks for your fast answer, but it doesn't solve my problem I think... I have a procedure, and grant execute to a user, but ->in<- this procedure I use another procedure, a system procedure (sp_addrolemember) and I can't grant a user rights for that one. Hey can execute the procedurte...

Hi, I don't know if it is possible, but I need to give certain Users the right to add or drop other users to roles. I would need a procedure which will simplified look like this: CREATE PROCEDURE dbo.add AS EXEC sp_addrolemember 'role', 'user' GO The Problem is, that no User can execute this...