Permission to SET NOCOUNT ON

  • What permission needs to be set to allow SET NOCOUNT ON to be executed? I don't want to give loads of permissions just for this one SET statement.

    Thanks in advance,

  • DOH,

    I meant that to be SET IDENTITY_INSERT

    Sorry

  • 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.

  • Thanks,

    I was just wondering whether there was something else I could do which wouldn't give permissions for all DDL, just the SET IDENTITY_INSERT

  • You can either change the owner of the object to you user. Create a role and add that user to it and change the owner of the object to role. Give the user db_owner role

    Simon Sabin

    Co-author of SQL Server 2000 XML Distilled

    http://www.amazon.co.uk/exec/obidos/ASIN/1904347088


    Simon Sabin
    SQL Server MVP

    http://sqlblogcasts.com/blogs/simons

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply