Sybase Technical Library - Product Manuals Home
[Search Forms] [Previous Section with Hits] [Next Section with Hits] [Clear Search] Expand Search
Structure of Embedded SQL programs [Table of Contents] Loading the interface library dynamically

[-] Chapter 2: The Embedded SQL Interface
[-] Application development using Embedded SQL
[-] User IDs and database authorization

User IDs and database authorization

The CONNECT statement specifies a user ID and password to be used for checking the permissions for any dynamic SQL statements that are used in the program (defined in Dynamic SQL statements ). It is also used for authorization of any static statements that are contained in modules preprocessed without the SQL preprocessor -l option. The -l option provides user identification.

Static SQL statements in modules that are preprocessed with the -l option will have the authorization checked at execution time using the user ID and password specified with the -l option. This is how privileged commands can be executed by non-privileged users under C program control.

Structure of Embedded SQL programs [Table of Contents] Loading the interface library dynamically