SET IDENTITY_INSERT Privileges?

From: Satish Balusa (sbalusa_nospam_at_corillian.com)
Date: 08/27/03 

Date: Tue, 26 Aug 2003 16:33:28 -0700

We have a "SET IDENTITY_INSERT " statement in a stored procedure and the
stored procedure has been granted execution privileges to a user 'xyz'. This
user 'xyz' is Neither a dbo Nor part of db_ddladmin. role. When the stored
procedure is being executed I get a permission denied msg.

>From BOL
Execute permissions default to the sysadmin fixed server role, and the
db_owner and db_ddladmin fixed database roles, and the object owner.

So my question is : How do I grant permission to a SET Statement??

Any help in this regrad is appreciated.
TIA
~Sat

Relevant Pages

  • Re: Temporary results used by SP
    ... You can create the temp table prior to the execution of the stored procedure and have the sp insert ... > b) use the data in "xyz" to do something ...
    (microsoft.public.sqlserver.programming)
  • Re: chooses not to generate code at all
    ... >>>DBMS is so that the DBMS engine can execute it when triggered by some ... If there is no trigger, ... Stored procedure is one thing. ... > If the procedure execution is not triggered by DBMS ...
    (comp.object)
  • Re: Stored Procedures vs DTS vs Jobs
    ... A stored procedure is complied code meaning that SQL Server has already ... > execution time, ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL DBA Consultants
    ... When I mentioned "loops" it's just ... > because that's the way it appears if you trace the execution. ... > SQL statement is constructed. ... >> sql within a stored procedure I am guessing that you are building and ...
    (microsoft.public.sqlserver.programming)
  • Re: Deadlock between Distribution Agent and Distribution Agent Cle
    ... stored procedure at the subscriber will have. ... replication to the subscriber and the possibility of moving the ... > obtains will be released at the end of its execution. ... >> Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)