Skip to Content

Identity_insert issue for a user

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 18 at 09:46 PM

    Hi there, what module are you working with here? Also have you checked with your DBA/Basis teams?

    Matt

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 19 at 07:36 PM

    This is to be given for the qa/ dev. I can do the functions as a sa/ DBA but need to give them Identity_Insert only to that specific database or just object (even better) without giving the sa role or dbo.

    Add comment
    10|10000 characters needed characters exceeded