authen
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_tr_permission_init
Parameters
Name
Type
Mode
Definition
BEGIN INSERT INTO group_permission(group_id, code) SELECT g.id, new.code FROM user_group g WHERE g.group_type= 'S' ON CONFLICT DO NOTHING; INSERT INTO user_permission(prop_id, user_id, code) SELECT u.prop_id, u.user_id, new.code FROM user_property u join users usr on usr.id = u.user_id join user_group g on usr.user_group_id = g.id WHERE g.group_type= 'S' ON CONFLICT DO NOTHING; RETURN NULL; END