Kbase P19593: SQL-92 error 7872 while granting privileges in 9.1C or earlier
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/04/2005 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1A
Progress 9.1B
Progress 9.1C
SYMPTOM(s):
Getting error 7872 when attempting to grant privileges within a database while there are SQL-92 and/or 4GL users connected to the database.
Failure to acquire exclusive schema lock for DDL operation. (7872)
CAUSE:
Enhancement Request# 20020208-034
CAUSE:
Progress 9.1C or earlier maintain a schema lock during the life of the connection.
FIX:
Upgrade to Progress 9.1D or later. The SQL-92 schema lock has been moved from the connection level down to the transaction level. This means that 4GL and SQL-92 users can remain connected to the database, but may not have any open transactions when you are attempting to GRANT privileges via SQL-92.