Topics

1

PSOUG / SELECT on a sequence and nextval

« on: September 23, 2009, 09:44:01 am »

Is it possible to grant SELECT on a sequence to a user (readonly user), but user should not be able to increment the sequence by using nextval on that sequence?

 Because if it does so, the user is not "readonly".