docs: sections: 2 rows where breadcrumbs = "["Authentication and permissions", "Configuring permissions in metadata.json"]", page = "authentication" and references = "[]"

2 rows where breadcrumbs = "["Authentication and permissions", "Configuring permissions in metadata.json"]", page = "authentication" and references = "[]"

Search:

descending

id ▼	page	ref	title	content	breadcrumbs	references
authentication:authentication-permissions-database	authentication	authentication-permissions-database	Controlling access to specific databases	To limit access to a specific private.db database to just authenticated users, use the "allow" block like this: { "databases": { "private": { "allow": { "id": "*" } } } }	["Authentication and permissions", "Configuring permissions in metadata.json"]	[]
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
);