Skip to Content
0
Former Member
Jan 16, 2018 at 08:57 PM

Identity_insert issue for a user

179 Views Last edit Jun 17, 2018 at 04:12 AM 3 rev

There is a requirement or an application user to set the Identity_Insert ON within a code. It states needs to be a dbo or sa_role.

Sybase ASE 15.7

error message

java.sql.SQLException: Permission denied. You must be either the database or the object owner or have sa_role to perform this operation.

There were errors trying to grant the permission to the user. So, created a procedure and added execute permission but still comes with the same errors.