Kbase P10499: Error 7677 when attempting to use Sequence
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/19/2010 |
|
Status: Verified
SYMPTOM(s):
Error 7677 when attempting to use Sequence
[JDBC Progress Driver]:permission denied (7677)
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.1x
OpenEdge 10.x
CAUSE:
Access rights to the sequence has to be granted to the user that wants to use it
FIX:
Syntax to give access rights to a sequence:
GRANT UPDATE ON SEQUENCE pub.<sequence_name> TO <user>;
Example:
Connect as user pub:
create sequence pub.mysequence;
commit;
GRANT UPDATE ON SEQUENCE pub.mysequence to test;
commit;
grant select on pub.mysequence to test;
commit;
Connect as user test:
select pub.mysequence.NEXTVAL from pub.test;