SQLite authorization action code (AuthorizerActionCodes) _ MySQL

Source: Internet
Author: User
**************************************** * ** 3rd ************** 4th ************ # defineSQLITE_CREATE_INDEX1 * IndexNameTableName * # defineSQ...
/*******************************************3rd ************ 4th ***********/#define SQLITE_CREATE_INDEX          1  /* Index Name      Table Name      */#define SQLITE_CREATE_TABLE          2  /* Table Name      NULL            */#define SQLITE_CREATE_TEMP_INDEX     3  /* Index Name      Table Name      */#define SQLITE_CREATE_TEMP_TABLE     4  /* Table Name      NULL            */#define SQLITE_CREATE_TEMP_TRIGGER   5   /*Trigger Name    Table Name      */#define SQLITE_CREATE_TEMP_VIEW      6  /* View Name       NULL            */#define SQLITE_CREATE_TRIGGER        7  /* Trigger Name    Table Name      */#define SQLITE_CREATE_VIEW           8  /* View Name       NULL            */#define SQLITE_DELETE                9   /* Table Name      NULL            */#define SQLITE_DROP_INDEX           10  /* Index Name      Table Name      */#define SQLITE_DROP_TABLE           11  /* Table Name      NULL            */#define SQLITE_DROP_TEMP_INDEX      12  /* Index Name      Table Name      */#define SQLITE_DROP_TEMP_TABLE      13  /* Table Name      NULL            */#define SQLITE_DROP_TEMP_TRIGGER    14  /* Trigger Name    Table Name      */#define SQLITE_DROP_TEMP_VIEW       15  /* View Name       NULL            */#define SQLITE_DROP_TRIGGER         16  /* Trigger Name    Table Name      */#define SQLITE_DROP_VIEW            17  /* View Name       NULL            */#define SQLITE_INSERT               18   /* Table Name      NULL            */#define SQLITE_PRAGMA               19   /* Pragma Name     1st arg or NULL */#define SQLITE_READ                 20   /* Table Name      Column Name     */#define SQLITE_SELECT               21   /* NULL            NULL            */#define SQLITE_TRANSACTION          22  /* Operation       NULL            */#define SQLITE_UPDATE               23   /* Table Name      Column Name     */#define SQLITE_ATTACH               24   /* Filename        NULL            */#define SQLITE_DETACH               25   /* Database Name   NULL            */#define SQLITE_ALTER_TABLE          26  /* Database Name   Table Name      */#define SQLITE_REINDEX              27   /* Index Name      NULL            */#define SQLITE_ANALYZE              28   /* Table Name      NULL            */#define SQLITE_CREATE_VTABLE        29  /* Table Name      ModuleName     */#define SQLITE_DROP_VTABLE          30  /* Table Name      ModuleName     */#define SQLITE_FUNCTION             31   /* NULL            Function Name   */#define SQLITE_SAVEPOINT            32  /* Operation       SavepointName  */#define SQLITE_COPY                  0   /* No longer used */#define SQLITE_RECURSIVE            33  /* NULL            NULL            */


Sqlite3_set_authorizer interface registers a callback function, which is called to authorize the execution of SQL statements. The second parameter of the callback function is an integer that specifies that the operations are authorized. the integer action codes can be used by the callback function.

The action number value specifies which operation is allowed. Whether the third and fourth parameters are NULL or other parameters depend entirely on the settings of the second parameter. The Fifth parameter is the database name (main, temp, or other) if applicable. the sixth parameter attempts to access the built-in trigger or view. if it is NULL, indicates The attempt to access the SQL code from the highest level (the 6th parameter to the authorizer callback is The nameof the inner-most trigger or view that is responsible for the access attempt orNULL if this access attempt is directly from top-level SQL code ).

The above is the content of SQLite authorization action code (AuthorizerAction Codes) _ MySQL. For more information, see PHP Chinese website (www.php1.cn )!

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.