Authorization Guide

About Authorization

We provide auth seeding artifacts in an SQL file auth_seed.sql, available on the release page.
Unpack these artifacts to src-gen/[Desired Product Name]/. You can use this file on your DBMS to seed the auth database.

Creating a New User

To create a new user, please execute the following SQL statement on your DBMS:

INSERT INTO auth_user_comp (id) VALUES ([unique integer]);
INSERT INTO auth_user_impl_passworded (id, password, allowedPermissions, name, email) 
VALUES ([unique integer], 'fd4f97ae96ed4c0268d0b275765c849ce511419d96d6290ed583b9516f8cab61dfeddf43a522167bc9fa1eaeebb72b88158a2e646d1006799eb65a0e5805341a', '', '[Your Name]', '[Your Google Email]');
                

Example:
INSERT INTO auth_user (id, password, allowedPermissions, name, email) VALUES (5, 'fd4f97ae96ed4c0268d0b275765c849ce511419d96d6290ed583b9516f8cab61dfeddf43a522167bc9fa1eaeebb72b88158a2e646d1006799eb65a0e5805341a', '', 'Samuel Tupa Febrian', 'samuel.febrian@gmail.com');

Note that the id field must be unique.

Assigning Account Roles

To assign a role to an account, execute the following SQL:

INSERT INTO auth_user_role (id, role, user) VALUES ([unique integer], [id role], [id user]);
                

Example:
INSERT INTO auth_user_role (id, role, user) VALUES (13, 1, 5);