Kbase P34884: Can't GRANT user permissions using SQL Explorer utility, Progress error (7872).
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Verified
FACT(s) (Environment):
UNIX
Progress 9.1x
SYMPTOM(s):
Failure to acquire exclusive schema lock for DDL operation(7872)
Problem occurs when trying to GRANT user permissions using SQL Explorer utility.
Multiple databases with the same name on this machine.
CAUSE:
Client connected to the wrong database.
FIX:
1. Started appropriate database in multi-user mode with a -S (Service Name / Port Number) making use of a unique TCP port.
2. Client connection was established using the correct -S value to point to the same TCP port that was used to start the database.
Client Command Example: sqlexp -db dbname -S 1234 -user sysprogress -password
GRANT statement worked just fine.
Example: sqlexp -db /wrkdir/myDB -S 1234 -user sysprogress -password abc