Authenticated SQL Anywhere applications

The OEM Edition of SQL Anywhere is provided for Sybase OEM Partners. With the OEM Edition of SQL Anywhere, an authenticated application can perform any operation on the database, subject to the permissions granted to the user ID.

Unauthenticated connections have read-only access, and can perform inserts, updates, and deletes on temporary tables. Using unauthenticated connections allows complex reports to be created using stored procedures, and accessed using reporting tools, such as Crystal Reports.

The authentication mechanism is independent of any application programming language or tool, and is carried out on every connection, so you can use both authenticated connections and more restricted unauthenticated connections in your application.

Authentication is not a security mechanism. Anyone running an unauthenticated database server against the database can perform any operation, subject to the usual SQL permissions scheme.


authenticated application development