docs: sections: 1 row where breadcrumbs contains "Authentication and permissions", references = "[]" and title = "Controlling access to specific canned queries"

1 row where breadcrumbs contains "Authentication and permissions", references = "[]" and title = "Controlling access to specific canned queries"

Search:

descending

id ▼	page	ref	title	content	breadcrumbs	references
authentication:authentication-permissions-query	authentication	authentication-permissions-query	Controlling access to specific canned queries	Canned queries allow you to configure named SQL queries in your metadata.json that can be executed by users. These queries can be set up to both read and write to the database, so controlling who can execute them can be important. To limit access to the add_name canned query in your dogs.db database to just the root user : { "databases": { "dogs": { "queries": { "add_name": { "sql": "INSERT INTO names (name) VALUES (:name)", "write": true, "allow": { "id": ["root"] } } } } } }	["Authentication and permissions", "Configuring permissions in metadata.json"]	[]

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE [sections] (
   [id] TEXT PRIMARY KEY,
   [page] TEXT,
   [ref] TEXT,
   [title] TEXT,
   [content] TEXT,
   [breadcrumbs] TEXT,
   [references] TEXT
);