Could someone explain why Servoy cannot see the tables created by a DB user other than the one specified in the connection? I’m using Sybase SQLAnywhere and I have created my DB schema logged as “root”. I created the Servoy connection to the DB server using another user called “servoy” with all the same privileges of root, but then Servoy don’t see the data and the tables. The queries just fail saying tables don’t exist.
Why does this happen? Is there any purpose? I’d like to manage my DB to have a specific user for my Servoy application.
Thanks.
Did you restart servoy server/developer after adding the new database?
Have you granted permissions on the tables for that user? Even if you make the new user a DBA level user, you will still need to grant permissions for the user.
For details on how to do this:
http://www.ianywhere.com/developer/prod … rgrtv.html
Regards,
Jason
I haven’t granted the permissions, however it’s still strange because using any database manager like Sybase Central I am able to manager all tables no matter the user that created them, as long as it has DBA access rights.
Well, thanks a lot for the feedback.