Menu
I have a new sequence in my database.
What permissions do I need to grant to my web user in order for the sequence to be used? I tried granting select on the sequence, but the web user still can't seem to see it.
291
The following privileges are valid for sequences: SELECT: Execute functions CURRVAL and NEXTVAL on the specified sequences. ALTER: Modify a sequence's DDL with ALTER SEQUENCE. DROP: Drop this sequence with DROP SEQUENCE .
GRANT CREATE ANY SEQUENCE, ALTER ANY SEQUENCE, DROP ANY SEQUENCE, SELECT ANY SEQUENCE TO my_user; The owner of a sequence has full privileges on the sequence. Another user can be given access to the sequence by granting the SELECT object privilege.
You need the CREATE PROCEDURE privilege to create a procedure, function, package definition, or package body if it is being created in your own schema, or CREATE ANY PROCEDURE if it is being created in any schema other than your own.
I think "select" should be sufficient. Is your query correctly qualifying the schema that the sequence exists in?
select someschema.somesequence.nextval from dual;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
