Product: Aqua Data Studio
Version: 12.0.0-rc-23-12
Build #: 29800
Build Date: 2012-Oct-18 06:57:50 AM

1. Take Sybase ASE 15.5 DBA Tool --> Security Manager

2. Click on Users Tab and select the database Northwind

3. Right click on the user dbo and SElect View User.

4. Click on the General --> Object Permissions button on the new tab that opens up

5. Select permissions for objects --> Procedures and you get an exception in error log as below

Notes:

This does not occur if you take the user properties from the user tree node. (Databases-->Northwind-->Users-->dbo)

This only occurs the first time and if we change the values in the drop down for objects and change it back to procedures it does not occur again

This does not occur in ADS 11.0

com.sybase.jdbc4.jdbc.SybSQLException: Execute cursor 'jconnect_implicit_19' is declared on a procedure which contains a non-SELECT or a SELECT with a COMPUTE clause. For the declaration of this cursor to be legal it should have a single SELECT statement without a COMPUTE clause.

    at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:3952)
    at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3095)
    at com.sybase.jdbc4.tds.Tds.getResultSetResult(Tds.java:3818)
    at com.sybase.jdbc4.tds.TdsCursor.open(TdsCursor.java:329)
    at com.sybase.jdbc4.jdbc.SybStatement.executeQuery(SybStatement.java:2030)
    at com.sybase.jdbc4.jdbc.SybStatement.executeQuery(SybStatement.java:524)
    at \\...\\ .\\हिñçêČάй語简�?한\\.xᜫꐠ⠞ꁆ while interface.executeQuery(Unknown Source)
    at \\...\\ .\\हिñçêČάй語简�?한\\.h⣊⠳ꂛꍔ.a(Unknown Source)
    at \\...\\ .\\हिñçêČάй語简�?한\\.h⣊⠳ꂛꍔ.a(Unknown Source)
    at \\...\\ .\\हिñçêČάй語简�?한\\.Aꁮꈘ⡌ꇎ const.a(Unknown Source)
    at \\...\\ .\\हिñçêČάй語简�?한\\.Yꏦᛦꁷꎐ.run(Unknown Source)