1.Dd January 24, 2024 2.Dt SQLITE_CREATE_INDEX 3 3.Os 4.Sh NAME 5.Nm SQLITE_CREATE_INDEX , 6.Nm SQLITE_CREATE_TABLE , 7.Nm SQLITE_CREATE_TEMP_INDEX , 8.Nm SQLITE_CREATE_TEMP_TABLE , 9.Nm SQLITE_CREATE_TEMP_TRIGGER , 10.Nm SQLITE_CREATE_TEMP_VIEW , 11.Nm SQLITE_CREATE_TRIGGER , 12.Nm SQLITE_CREATE_VIEW , 13.Nm SQLITE_DELETE , 14.Nm SQLITE_DROP_INDEX , 15.Nm SQLITE_DROP_TABLE , 16.Nm SQLITE_DROP_TEMP_INDEX , 17.Nm SQLITE_DROP_TEMP_TABLE , 18.Nm SQLITE_DROP_TEMP_TRIGGER , 19.Nm SQLITE_DROP_TEMP_VIEW , 20.Nm SQLITE_DROP_TRIGGER , 21.Nm SQLITE_DROP_VIEW , 22.Nm SQLITE_INSERT , 23.Nm SQLITE_PRAGMA , 24.Nm SQLITE_READ , 25.Nm SQLITE_SELECT , 26.Nm SQLITE_TRANSACTION , 27.Nm SQLITE_UPDATE , 28.Nm SQLITE_ATTACH , 29.Nm SQLITE_DETACH , 30.Nm SQLITE_ALTER_TABLE , 31.Nm SQLITE_REINDEX , 32.Nm SQLITE_ANALYZE , 33.Nm SQLITE_CREATE_VTABLE , 34.Nm SQLITE_DROP_VTABLE , 35.Nm SQLITE_FUNCTION , 36.Nm SQLITE_SAVEPOINT , 37.Nm SQLITE_COPY , 38.Nm SQLITE_RECURSIVE 39.Nd authorizer action codes 40.Sh SYNOPSIS 41.In sqlite3.h 42.Fd #define SQLITE_CREATE_INDEX 43.Fd #define SQLITE_CREATE_TABLE 44.Fd #define SQLITE_CREATE_TEMP_INDEX 45.Fd #define SQLITE_CREATE_TEMP_TABLE 46.Fd #define SQLITE_CREATE_TEMP_TRIGGER 47.Fd #define SQLITE_CREATE_TEMP_VIEW 48.Fd #define SQLITE_CREATE_TRIGGER 49.Fd #define SQLITE_CREATE_VIEW 50.Fd #define SQLITE_DELETE 51.Fd #define SQLITE_DROP_INDEX 52.Fd #define SQLITE_DROP_TABLE 53.Fd #define SQLITE_DROP_TEMP_INDEX 54.Fd #define SQLITE_DROP_TEMP_TABLE 55.Fd #define SQLITE_DROP_TEMP_TRIGGER 56.Fd #define SQLITE_DROP_TEMP_VIEW 57.Fd #define SQLITE_DROP_TRIGGER 58.Fd #define SQLITE_DROP_VIEW 59.Fd #define SQLITE_INSERT 60.Fd #define SQLITE_PRAGMA 61.Fd #define SQLITE_READ 62.Fd #define SQLITE_SELECT 63.Fd #define SQLITE_TRANSACTION 64.Fd #define SQLITE_UPDATE 65.Fd #define SQLITE_ATTACH 66.Fd #define SQLITE_DETACH 67.Fd #define SQLITE_ALTER_TABLE 68.Fd #define SQLITE_REINDEX 69.Fd #define SQLITE_ANALYZE 70.Fd #define SQLITE_CREATE_VTABLE 71.Fd #define SQLITE_DROP_VTABLE 72.Fd #define SQLITE_FUNCTION 73.Fd #define SQLITE_SAVEPOINT 74.Fd #define SQLITE_COPY 75.Fd #define SQLITE_RECURSIVE 76.Sh DESCRIPTION 77The 78.Fn sqlite3_set_authorizer 79interface registers a callback function that is invoked to authorize 80certain SQL statement actions. 81The second parameter to the callback is an integer code that specifies 82what action is being authorized. 83These are the integer action codes that the authorizer callback may 84be passed. 85.Pp 86These action code values signify what kind of operation is to be authorized. 87The 3rd and 4th parameters to the authorization callback function will 88be parameters or NULL depending on which of these codes is used as 89the second parameter. 90The 5th parameter to the authorizer callback is the name of the database 91("main", "temp", etc.) if applicable. 92The 6th parameter to the authorizer callback is the name of the inner-most 93trigger or view that is responsible for the access attempt or NULL 94if this access attempt is directly from top-level SQL code. 95.Sh IMPLEMENTATION NOTES 96These declarations were extracted from the 97interface documentation at line 3234. 98.Bd -literal 99/******************************************* 3rd ************ 4th ***********/ 100#define SQLITE_CREATE_INDEX 1 /* Index Name Table Name */ 101#define SQLITE_CREATE_TABLE 2 /* Table Name NULL */ 102#define SQLITE_CREATE_TEMP_INDEX 3 /* Index Name Table Name */ 103#define SQLITE_CREATE_TEMP_TABLE 4 /* Table Name NULL */ 104#define SQLITE_CREATE_TEMP_TRIGGER 5 /* Trigger Name Table Name */ 105#define SQLITE_CREATE_TEMP_VIEW 6 /* View Name NULL */ 106#define SQLITE_CREATE_TRIGGER 7 /* Trigger Name Table Name */ 107#define SQLITE_CREATE_VIEW 8 /* View Name NULL */ 108#define SQLITE_DELETE 9 /* Table Name NULL */ 109#define SQLITE_DROP_INDEX 10 /* Index Name Table Name */ 110#define SQLITE_DROP_TABLE 11 /* Table Name NULL */ 111#define SQLITE_DROP_TEMP_INDEX 12 /* Index Name Table Name */ 112#define SQLITE_DROP_TEMP_TABLE 13 /* Table Name NULL */ 113#define SQLITE_DROP_TEMP_TRIGGER 14 /* Trigger Name Table Name */ 114#define SQLITE_DROP_TEMP_VIEW 15 /* View Name NULL */ 115#define SQLITE_DROP_TRIGGER 16 /* Trigger Name Table Name */ 116#define SQLITE_DROP_VIEW 17 /* View Name NULL */ 117#define SQLITE_INSERT 18 /* Table Name NULL */ 118#define SQLITE_PRAGMA 19 /* Pragma Name 1st arg or NULL */ 119#define SQLITE_READ 20 /* Table Name Column Name */ 120#define SQLITE_SELECT 21 /* NULL NULL */ 121#define SQLITE_TRANSACTION 22 /* Operation NULL */ 122#define SQLITE_UPDATE 23 /* Table Name Column Name */ 123#define SQLITE_ATTACH 24 /* Filename NULL */ 124#define SQLITE_DETACH 25 /* Database Name NULL */ 125#define SQLITE_ALTER_TABLE 26 /* Database Name Table Name */ 126#define SQLITE_REINDEX 27 /* Index Name NULL */ 127#define SQLITE_ANALYZE 28 /* Table Name NULL */ 128#define SQLITE_CREATE_VTABLE 29 /* Table Name Module Name */ 129#define SQLITE_DROP_VTABLE 30 /* Table Name Module Name */ 130#define SQLITE_FUNCTION 31 /* NULL Function Name */ 131#define SQLITE_SAVEPOINT 32 /* Operation Savepoint Name */ 132#define SQLITE_COPY 0 /* No longer used */ 133#define SQLITE_RECURSIVE 33 /* NULL NULL */ 134.Ed 135.Sh SEE ALSO 136.Xr sqlite3_set_authorizer 3 137