Solved

Microsoft

Posted on 2013-01-23
3
154 Views
Last Modified: 2013-06-19
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
Comment
Question by:Sandeepiii
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 17

Assisted Solution

by:Barry Cunney
Barry Cunney earned 250 total points
ID: 38809399
GRANT EXECUTE ON spLog_Error TO [your_user]
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 250 total points
ID: 38812755
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
 

Author Closing Comment

by:Sandeepiii
ID: 39259579
good answer.
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sql query help 15 53
T-SQL: Stored Procedure Syntax 3 33
Connect remotely to SQL Server DB without TCP/IP enabled? 2 35
Running Total Using new MS SQL Function 21 50
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question