SELECT on a sequence and nextval

[ssharma]

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".

[cory]

Would creating a view returning last_number+increment_by work for you?  The users can be granted read only access to the view.

CREATE VIEW sequences_next_number  AS
  SELECT a.sequence_name
     , a.last_number+increment_by as next_number
   FROM all_sequences a;