Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

IDENTITY INSERT PERSMISSION

Status
Not open for further replies.
MinniMouse

MinniMouse

Programmer
May 11, 2004
9
CA
What permission has to be granter to a user in order to be able to SET INDENTITY ON or OFF



Hexadecimal
 
Sort by date Sort by votes
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.



Andel
andel@barroga.net
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheBugSlayer
  • Locked
  • Question
High Availability - insert fails on primary replica but runs on secondary after failover.
Replies
0
Views
307
TheBugSlayer
TheBugSlayer
jcaulder
  • Locked
  • Question
insert query timing out reasons
Replies
2
Views
63
jcaulder
jcaulder
joejack0330
  • Locked
  • Question
Insert Column In Huge Datbases.
Replies
7
Views
106
jsteph
jsteph
PoppapumpJ
  • Locked
  • Question
Add identity with ALTER TABLE SQL statement
Replies
1
Views
46
mrdenny
mrdenny
ice789911
  • Locked
  • Question
Insert into bit field 1
Replies
2
Views
45
ice789911
ice789911

Part and Inventory Search

Sponsor

Back
Top