Kbase P112343: Error (7574) when a DBA user executes a stored procedure owned by PUB, which creates a table in PUB
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/01/2006 |
|
Status: Unverified
SYMPTOM(s):
Error (7574) when executing a stored procedure
No RESOURCE privileges (7574)
The stored procedure is executed by a user with DBA privilege
The stored procedure belongs to the schema 'PUB'
The stored procedure creates a table in the schema 'PUB'
Error (7572) appears when calling the stored procedure with the prefix 'pub'
No DBA access rights (7572)
CAUSE:
This is expected behavior.
When the stored procedure is created by the user with DBA privilege in the PUB schema, the grantor is PUB, and the grantee is PUB. This stored procedure is also owned by PUB.
The stored procedures are executed with the OWNER's rights and not the INVOKER's right; in this case the owner is PUB.
Since PUB does not have any RESOURCE and DBA privileges, the user PUB can not create any table.
Therefore, that's why the error (7574) occurs.
FIX:
To be able to create a table in the schema PUB when executing a stored procedure owned by PUB, the user PUB needs to have at least RESOURCE privilege.
This can be done by running the following query:
GRANT RESOURCE TO PUB;