Sybase Philippines

Hi to all,

Im using ASAny 9 as my database and VB6 as my front end.

Previously, im using the default user DBA as my user login during connection. So far, my application is running smoothly with this user.

But for security measure, im trying to create new user and used this instead of the DBA.

Now, my problem is that with I try to query my table the server doesn't response. And when I check it at Sybase Central the last request would be CURSOR_OPEN and the table open Exclusively.

Why is this happen when I use other user other than DBA.

Note: My tables, Views and Functions are all created using DBA, i also give my new user a full priviledges.

Hope somebody response with this topic. And my apology to by bad english

doy_nick wrote:Hi to all,

Im using ASAny 9 as my database and VB6 as my front end.

Previously, im using the default user DBA as my user login during connection. So far, my application is running smoothly with this user.

But for security measure, im trying to create new user and used this instead of the DBA.

Now, my problem is that with I try to query my table the server doesn't response. And when I check it at Sybase Central the last request would be CURSOR_OPEN and the table open Exclusively.

Why is this happen when I use other user other than DBA.

Note: My tables, Views and Functions are all created using DBA, i also give my new user a full priviledges.

Hope somebody response with this topic. And my apology to by bad english

if it isn't too much trouble can you recreate the objects under this new user's login.