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

1 row where breadcrumbs = "["Authentication and permissions", "Access permissions in "]", references = "[]" and title = "Access to specific canned queries"

Search:

descending

id ▼	page	ref	title	content	breadcrumbs	references
authentication:authentication-permissions-query	authentication	authentication-permissions-query	Access to specific canned queries	Canned queries allow you to configure named SQL queries in your datasette.yaml 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 : [[[cog config_example(cog, """ databases: dogs: queries: add_name: sql: INSERT INTO names (name) VALUES (:name) write: true allow: id: - root """) ]]] [[[end]]]	["Authentication and permissions", "Access permissions in "]	[]

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
);