in the stored procedure, I have "set identity_insert TableName on"
then I grant the exec of this stored procedure to userA
but when I run the stored procedure using userA's login
I got an error saying the set is not permitted for userA on table "TableName"
the userA is not the database owner, its roles are public, db_datareader, db_datawriter.
Can you tell me why I got the error? is there any special reason for the set identity_insert?
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.