milkcrate_prod
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
create_role_readonly
Parameters
Name
Type
Mode
irolename
text
IN
ipassword
text
IN
iidcommunity
integer
IN
Definition
begin insert into config_role_community (rolename, id_community) VALUES (irolename,iidcommunity); execute format($f$create role %I with login password '%s'$f$,irolename,ipassword); execute format($f$grant group_read to %s$f$,irolename); return 'success'; end;