• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 158
  • Last Modified:

Microsoft

Hi,
I need to give assign spLog_Error execute permission for particular sql user,can you help how can i assign this permission for sql user so tht he can execute the stored Procedure.
0
Sandeepiii
Asked:
Sandeepiii
2 Solutions
 
Barry CunneyCommented:
GRANT EXECUTE ON spLog_Error TO [your_user]
0
 
Anthony PerkinsCommented:
Does the Stored Procedure use Dynamic SQL? If the answer is yes than in addition to EXECUTE permissions you will need explicit permissions for those Dynamic SQL commands.
0
 
SandeepiiiAuthor Commented:
good answer.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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