Core user rights

From Dokumentacje GRYFsoft

Table that stores right namespaces linked to user

Column Type Not Null Default Comment Relations
user_name character varying NOT NULL postgres username n to 1 with core_user.user_name
user_namespace character varying NOT NULL linked namespace

create table

CREATE TABLE "public"."core_user_rights" (
  "user_name" VARCHAR NOT NULL, 
  "user_namespace" VARCHAR NOT NULL
) WITHOUT OIDS;

indexes

CREATE INDEX indx_user_rights_name ON core_user_rights USING btree (user_name);
CREATE INDEX indx_user_rights_namespace ON core_user_rights USING btree (user_namespace);

initional fill

You should run this script to have access to administration options.

INSERT INTO core_user_rights
 (user_name,user_namespace)
 SELECT rolname,'tools:admin'
 FROM pg_roles
 WHERE rolsuper = TRUE