diff options
| -rw-r--r-- | install.sql | 13 |
1 files changed, 12 insertions, 1 deletions
diff --git a/install.sql b/install.sql index 5fe7c82..4f73907 100644 --- a/install.sql +++ b/install.sql @@ -13,13 +13,24 @@ CREATE USER ambassador; -- Now, create the view that ambassador actually uses CREATE VIEW public_toots AS - SELECT * + SELECT + statuses.id, statuses.reblog_of_id, statuses.account_id, + statuses.updated_at, status_stats.favourites_count FROM statuses + LEFT OUTER JOIN status_stats + ON statuses.id = status_stats.status_id WHERE visibility = 0 ; +-- Change 13104 to your ambassador's account ID +CREATE VIEW blocks_ambassador AS + SELECT account_id + FROM blocks + WHERE target_account_id = 13104; + -- Make sure the role doesn't have access to anything undesireable REVOKE ALL FROM ambassador; -- Let ambassador select from the view GRANT SELECT ON public_toots TO ambassador; +GRANT SELECT ON blocks_ambassador TO ambassador; |