summaryrefslogtreecommitdiff
path: root/db/rest/post/api_post.sql
blob: a91d9d21d9442b6f51d9d5556c8a3dd97680384e (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
CREATE VIEW api.post AS
	SELECT
		p.id,
		p.user_id,
		p.content,
		p.date
	FROM
		admin.post p;

GRANT SELECT ON TABLE api.post
	TO rest_anon, rest_user;
GRANT SELECT ON TABLE admin.post
	TO rest_anon, rest_user;