"Mario Wolff" <[EMAIL PROTECTED]> wrote: > Hello Group, > i try to migrate my (alpha-state) project from sqlite2 to sqlite3. To > realize table based acl's i call explain and take the > OpenRead/OpenWrite lines and check for p3 entry which gives the > affected table. With sqlite3 the p3 is not set! >
The opcodes in SQLite are not part of the defined interface and are subject to change without notice. Opcodes can and do change sometimes drastically between point releases. Do not write code that reads opcodes. Doing so is considered bad style. To implement table or even column-level access control, use the sqlite3_set_authorizer() API. There are examples of how to do this in the source code to CVSTrac. http://www.cvstrac.org/ -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------