Oracle: What permissions do you need to grant for consistency?

Question

I have a new sequence in my database.

What permissions do I need to grant my web user in order for the sequence to be used? I tried to provide the selection in sequence, but the web user still cannot see it.

Answer 1

I think that “picking” should be enough. Does your request match the schema in which the sequence exists?

select someschema.somesequence.nextval from dual; 

Answer 2

 GRANT SELECT, ALTER ON SOMESCHEMA.SQ_SOMESEQUENCE TO OTHERSCHEMA WITH GRANT OPTION;