Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 370
  • Last Modified:

permission denied for excution store procedure

expert,

I copied sproc from server 1 to server 2 and run it in server 2, it came out with error like
Server: Msg 262, Level 14, State 1, Procedure ...
CREATE PROCEDURE permission denied in database 'master'
I am in sysAdmin level I am able to exec this sproc, but it doens't.

Can you help? Thank you,
0
yrcdba7
Asked:
yrcdba7
  • 3
1 Solution
 
bull_riderCommented:
The user you are logged in to server 2 does not have CREATE PROCEDURE permissions I guess. Just double check.
0
 
RiteshShahCommented:
can you give  db_owner role to your user? it may solve the problem
0
 
yrcdba7Author Commented:
I have SA role in server 2, I also gave db_owner. then tried again, it got the same error.
0
 
yrcdba7Author Commented:
it is working right now after I refreshed my login in EM.  Thank you!!
0
 
yrcdba7Author Commented:
Thank you for your recommandation, it saved my time.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now