× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tariqrahiman reported 2013-10-24T18:31:47Z  · swissarmyknife(*) last modified 2013-10-25T20:54:08Z

Indicate the list of locks could not be determined due to exception


customer request
Priority Low
Complexity Unknown
Component DBA-T - Sybase - Session Mngr
Version 14.0

 

Version: 14.0.3-3
Build #: 34503
Build Date: 2013-Oct-21 10:53:58 AM
 
On Sybase ASE Servers, the monitoring of the syslocks in the session manager , Locks Tab does NOT return anything, even if there are locks,but there is a lock to an object the user does not have access to.
 
I tested with a user who does not have permissions on a database and got the exception Server user id is not a valid user in database ...in error log, but no indication is given to the user in the Session Manager.
 
To reproduce:
 

1. Open SQL Log and Error Log

2. Connect to Sybase ASE 15 at 10.168.11.46:5000 with user named erwin and standard password and open Session Manafer and go to the Locks Tab

3. Now connect to the same server using user sa and open a query window to sybsecurity database and execute the query

 

begin transaction
lock table dbo.titles in share mode

 

4. Now another open erwin user Session Manager and go to the locks tab. You can see that now the 2 already listed locks are not displayed for user erwin who doesnt have access to sybsecurity database.

In error log, an exception is generated. Since the JDBC driver throws an exception, no data is returned to Aqua Data Studio.

It would be nice to indicate to the user that the list of locks could not be determined due to exception in the Session Manager

 

1 attachment

Issue #10583

Closed
Fixed
Resolved 2013-10-24T22:14:00Z
 
 
Completion
No due date
Fixed Build v14.0.3-5
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017