SQL encryption, and passwords

Classic Servoy
1

Sorry if this is a dumb question.

I’m creating DBs in Sybase ASA and there’s an option to use encryption, simple or strong with an encyption key.

I’ve tried setting simple encryption but can’t connect to the db from Servoy.

When would I want to use this, and how is it used within Servoy.

I want to make sure that the data in the ASA SQL can’t be peaked at by bypassing the Servoy frontend and looking at the DB directly.

Also, where do we change the default User and Password combination dba/sql?

Can SQL db encryption and passwords be changed after the db’s been created?

If it’s in the documentation, I apologise, but I couldn’t find it.

2

Simple database encryption is moretheless a data ofuscation to protect people from eye-balling the data in the file on the file system.

You would also need to protect your user ids, passwords and user permissions. Change user ids and passwords that have well known paswords. See the GRANT statement in the online help to get informatino on controlling users permissions.

3

antonio:
Can SQL db encryption and passwords be changed after the db’s been created?
If it’s in the documentation, I apologise, but I couldn’t find it.

I have a hard time figuring this out, too… Is there a simple way to do this?