The AD Group to which I belong has db_owner permissions on database LandingZone. The application I am debugging, that is running under my ID, is doing a SELECT NEXT VALUE FOR ThisSchema.ThatSequence. I am getting the following error:

Msg 229, Level 14, State 5, Line 6
The UPDATE permission was denied on the object 'ThatSequence', database 'LandingZone', schema 'ThisSchema'.

I think I'm running into a Least Privilege issue but the production DBAs disagree.

Any suggestions?


Possible issue: Are you sure the application is using your login? The application may be using a different login than yours. Check the CONFIG file to see what login is being used when the application is running. If it's different, then that login is the one that needs right perms.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.