Permission denied to run set Identity_insert to table
-1
votes
1
answer
2040
views
I have just setup the ASE-ASE replication with a column as IDENTITY, when I tried to resume my DSI connection of my replication server, I'm hitting the error
Message from server: Message: 10369, State 2, Severity 14 -- 'Permission denied. You must be either the database or the object owner or have sa_role to perform this operation.
Further check from the dump queue, I could see some transaction is trying to do insert to the table with IDENTITY column, and probably it hits permission denied set identity_insert customer on insert into customer (id, name) values (1,'Ben')set identity_insert customer off
. May I know how can I grant my replication user to be able to run the set identity_insert
and set identity_update
command?
Appreciate if you could help. Thanks in advance.
Asked by Tittus
(33 rep)
Mar 8, 2018, 08:44 AM
Last activity: Oct 4, 2019, 04:04 AM
Last activity: Oct 4, 2019, 04:04 AM