Sample Header Ad - 728x90

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