Kbase P26269: Error 7574 when creating a sequence
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/06/2003 |
|
Status: Unverified
FACT(s) (Environment):
Windows
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Error 7574 when creating a sequence:
No RESOURCE privileges (7574)
Using SQL-92
CAUSE:
To create a sequence you must have DBA or RESOURCE privileges.
FIX:
Ensure that the user creating the sequence has the required permissions to do so.
Use GRANT statement to set the appropriate privilege.
This is the syntax to GRANT database-wide privileges:
SYNTAX
GRANT { RESOURCE, DBA } TO username [ , username ] , ... ;
e.g.
GRANT DBA on pub TO user1 ;
GRANT RESOURCE on pub TO user1 ;