If you have access to the server (physically or via software) you can check
files locked by user. How you do so depends on the server OS you are
running. Once there you can "delete" the connection. If you post that you
can be steered to the correct place.
If you don't have such access there is a reference to a utility in RScope
that provides information on locks, but I don't know if it includes detail
to the user level, and may depend on having the user's name (or some
personal identifier) in their rbase.cfg file (assuming that's how you do
it).
Dave
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Paul
> Sent: Wednesday, July 18, 2001 4:32 PM
> To: [EMAIL PROTECTED]
> Subject: How to find a user with a cursor lock on a table
>
>
> Occasionally a cursor lock will be left on a table during the
> day, and it is
> impossible to require all users to simultaneously disconnect from the
> production database to remove it.
>
> Is there a way to identify the user that has locked a table?
>
> Thanks,
> Paul
>
