1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
CREATE VIEW api.user AS
SELECT
u.id,
u.username,
NULL AS password,
u.role,
u.first_name,
u.last_name,
u.middle_name,
u.email,
u.gender,
u.join_date,
u.birth_date,
u.profile_avatar,
u.profile_banner,
u.profile_bio
FROM
admin.user u;
GRANT SELECT ON TABLE api.user
TO rest_anon, rest_user;
GRANT SELECT ON TABLE admin.user
TO rest_anon, rest_user;
|
