table security

I’d like to implement security on my Servoy solution, and I can’t figure out how to do it in Servoy, so it must be a Sybase thing. I want to be able to limit access to records based on certain fields. For example, a user working in Denver should see only customer records whose location=denver. They should not be able to see records in the same table for customers whose location=new york.

Can this be done through Servoy, and if not, can anyone tell me how to do this in Sybase, or point to a good reference?

thanks!

You can can do that in Servoy using a table filter.
Take look at the sample code of databaseManager.addTableFilterParam().
When the user logs in, you know its location and in the login method you can then add a filter for the customer table.

great suggestion, thanks. I’ve just implemented that, but I need one more hint: how do I know the users’ location? All I can see to define about a user (in users and groups) is the user name and the password.