5 lines
305 B
SQL
5 lines
305 B
SQL
SELECT set_config('app.tenant_id','11111111-1111-4111-8111-111111111111',true);
|
|
UPDATE memberships SET permissions=array_append(permissions,'apt:native_acceptance')
|
|
WHERE principal='simulated-testprincipal-a' AND NOT('apt:native_acceptance'=ANY(permissions));
|
|
SELECT set_config('app.tenant_id','',true);
|