October 21, 2002 at 2:19 am
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
DOH,
I meant that to be SET IDENTITY_INSERT
Sorry
October 21, 2002 at 3:41 am
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
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
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