Kbase P40410: Granting SQL permissions on Source database hangs
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/3/2003 |
|
Status: Unverified
FACT(s) (Environment):
Fathom High Availability Replication 1.0A
SYMPTOM(s):
Granting SQL permissions on Source database hangs
No errors generated.
No users connected to source database
Users still connected to target database
Example grant command:
"grant select on pub.customer to public"
CAUSE:
In order replicate the SQL permissions grant, An exclusive schema lock is also required on the target. If the operation hangs it indicates that a request for an exclusive schema lock has been made to the target, but not yet granted. To confirm, check the log files of both the source and target database.
FIX:
Disconnect users from the target. The exclusive schema lock will be granted and the command will execute.