CREATE TABLE grants (
    principal_id TEXT NOT NULL,
    role_id TEXT NOT NULL,
    PRIMARY KEY (principal_id, role_id)
);

CREATE INDEX idx_grants_principal ON grants(principal_id);
