Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: hydrorocks
- Content: Threads
- Order by date
-
Grant as db_owner
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...- hydrorocks
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
-
Stored Procedure Permissions
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...- hydrorocks
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
