![]() ![]() ![]() Msg 229, Level 14, State 5, Procedure sp_HelloWorld, Line 1 I'm also able to run the following: USE īut trying to execute the stored procedure from within the context of any other database while impersonating the user: USE MyDB I'm able to run EXEC dbo.sp_HelloWorld myself from any database on the server without issue. grant execute permission on stored procedure in master database create user in another database on server Here's what I've tried: -create procedure for purpose of testingĬREATE USER FOR LOGIN I have no problem executing such stored procedures myself from any database on the server, but I also have sysadmin privileges and would prefer to grant this user as few permissions as possible. I understand this isn't a recommended practice, but the decision to do so was made by someone else with more authority than me. Our developers have a domain account used by their application that needs to be able to execute stored procedures created in the master database using the "sp_" naming convention from other databases on the server (SQL Server 2012 Enterprise Edition). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |