Post reply

Permission to SET NOCOUNT ON

  • October 21, 2002 at 2:19 am

    #79242

    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,

  • October 21, 2002 at 2:45 am

    #438962

    DOH,

    I meant that to be SET IDENTITY_INSERT

    Sorry

  • October 21, 2002 at 3:41 am

    #438963

    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.

  • October 21, 2002 at 4:03 am

    #438969

    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

  • October 21, 2002 at 5:30 am

    #438990

    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