Skip to Content
0

Identity_insert issue for a user

Jan 16 at 08:57 PM

96

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Matt Pollicove
Jan 18 at 09:46 PM
0

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

Matt

Share
10 |10000 characters needed characters left characters exceeded
Aravind Diwakar Jan 19 at 07:36 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded