Kbase 40499: Error 7677 when attempting to use Sequence
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
Solution ID: P10499
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Error 7677 when attempting to use Sequence
[JDBC Progress Driver]:permission denied (7677)
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 test to test;
commit;
Connect as user test:
select pub.mysequence.NEXTVAL from pub.test;