What's the rationale for ALTER TABLE permission being required for SET IDENTITY_INSERT ON?

Channel:
Peter Schneider
Subscribers:
4,130
Published on ● Video Link: https://www.youtube.com/watch?v=QHQxt9q2_TE


Duration: 2:00
6 views
0

What's the rationale for ALTER TABLE permission being required for SET IDENTITY_INSERT ON?
I hope you found a solution that worked for you :)
The Content (except music & images) is licensed under (https://meta.stackexchange.com/help/licensing)CC BY-SA |
Thanks to all those great people for their contributions!

(dba.stackexchange.com/users/26463/john)John |
(dba.stackexchange.com/users/3690/martin-smith)Martin Smith |
A special thanks goes out to the (https://dba.stackexchange.com/questions/321264/whats-the-rationale-for-alter-table-permission-being-required-for-set-identity)Stackexchange community |

I wish you all a wonderful day! Stay safe :)

identity sql-server



Other Videos By Peter Schneider


2022-12-24Get attribute value from parent layer to child layer sharing same uniqueID
2022-12-24Terminology: Are a first-order filter and a single-pole filter always the same thing and complete...
2022-12-24How can I get back menu bar icon of an agent app?
2022-12-24How to hyphenate only words within a list?
2022-12-24Convert dB to ohms
2022-12-24How to create an interface in C that can work on two identical structs with differently named fields
2022-12-24PHP Warning Deprecated: Creation of dynamic property is deprecated
2022-12-24Is iostream a header or a library
2022-12-24Why isn't `which ls | file` working?
2022-12-24How do i write an if statement to be between two values?
2022-12-24What's the rationale for ALTER TABLE permission being required for SET IDENTITY_INSERT ON?
2022-12-24I have 1 TB disk but I'm only seeing 747 GB. How to recover the 253 GB missing?
2022-12-24Should we use require_once in a module's registration.php?
2022-12-24Is there a name for a sensor to linearly output values according to its supply voltage?
2022-12-24How to I remove Featured Image from the Posts/Category Lists?
2022-12-24Too many DML statemnts 151 in Future apex
2022-12-24Why does stripping metadata decrease the duration of my MP3 file by 0.03 seconds?
2022-12-24Centering operator between two underbraces
2022-12-24Assigning a subsection of C-style array using a std::array& without violating "strict aliasing" a...
2022-12-24Convert Hyper-V vhdx to iso
2022-12-24Do you know what 15180 means in relation to timestamp?


Tags:
identity
sql-server