I am trying to use Automatic Identity Range Management . However, the only way to ensure that my users can write INSERT to tables with identity columns is to do them db_owner. Did I miss something?
db_owner
For a complete background, please refer to my previous question: Allow non-db_owner INSERT permissions in merge replication with mgmt automatic authentication range
Apparently, they are mutually exclusive.
Microsoft ( , " " , ):
1) , , db_owner.SQL 2005/8 , , db_owner. ( ), db_owner. , , , db_owner, . , , , db_owner sp_adjustpublisheridentityrange (Transact-SQL).
1) , , db_owner.
SQL 2005/8 , , db_owner. ( ), db_owner. , , , db_owner, . , , , db_owner sp_adjustpublisheridentityrange (Transact-SQL).
!?!?! , , , db_owners?