Kbase P159482: Error 7512 trying to create a PUBLIC synonym
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/1/2010 |
|
Status: Unverified
SYMPTOM(s):
Error 7512 trying to create a PUBLIC synonym
Access denied (Authorization failed) (7512)
FACT(s) (Environment):
Connected using a user that has RESOURCE privileges
All Supported Operating Systems
Progress 9.1x
OpenEdge 10.x
OpenEdge Category: SQL
CAUSE:
User must have the DBA privilege to create public synonyms.
FIX:
Use a user that has RESOURCE and DBA privileges or add DBA privilege the current user.
To add DBA privilege do the following:
1) Using SQL explorer or other preferred SQL tool, connect the database using a sysprogress user or the current DBA of the database.
2) Use GRANT statement to set DBA privilege to the user.
This is the syntax to GRANT database-wide privileges:
SYNTAX
GRANT { RESOURCE, DBA } TO username [ , username ] , ... ;
EXAMPLE:
GRANT DBA TO dbuser1;
COMMIT;
3) Disconnect the database and reconnect now using the user and run CREATE SYNONYM.