Skip to main content

0004 · Credentials declare read or write access

Control namespace · version 4 · source

What it runs​

  • ALTER TABLE credential ADD COLUMN access text NOT NULL DEFAULT 'read_write' CHECK

SQL​

{schema} is replaced with the validated namespace name when the migration is applied.

6 lines
-- Copyright 2026 The Taisce Authors
-- SPDX-License-Identifier: Apache-2.0

-- Project credentials declare their memory authority. Ordinary issuance defaults to read/write.
ALTER TABLE {schema}.credential ADD COLUMN access text NOT NULL DEFAULT 'read_write'
    CHECK (access IN ('read_only','read_write'));