From: Michael Andreen <harv@ruin.nu>
Date: Sun, 27 Mar 2016 17:32:59 +0000 (+0200)
Subject: intel role
X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=commitdiff_plain;h=73119e806350719e2ce899bfbaa2ba19f0dc87d1

intel role
---

diff --git a/database/dbaccess.sql b/database/dbaccess.sql
new file mode 100644
index 0000000..d18277e
--- /dev/null
+++ b/database/dbaccess.sql
@@ -0,0 +1,36 @@
+/*
+CREATE ROLE intel;
+GRANT intel TO test;
+*/
+
+GRANT SELECT ON planets TO intel;
+GRANT SELECT ON planet_stats TO intel;
+GRANT SELECT ON current_planet_stats TO intel;
+GRANT SELECT ON current_planet_stats_full TO intel;
+GRANT SELECT ON galaxies TO intel;
+GRANT SELECT ON alliances TO intel;
+GRANT SELECT ON alliance_stats TO intel;
+GRANT SELECT ON alliance_resources TO intel;
+GRANT SELECT ON intel TO intel;
+GRANT SELECT ON intel_scans TO intel;
+GRANT SELECT ON scans TO intel;
+GRANT SELECT ON fleets TO intel;
+GRANT SELECT ON launch_confirmations TO intel;
+GRANT SELECT ON fleet_scans TO intel;
+GRANT SELECT ON fleet_ships TO intel;
+GRANT SELECT ON planet_scans TO intel;
+GRANT SELECT ON current_planet_scans TO intel;
+GRANT SELECT ON development_scans TO intel;
+GRANT SELECT ON current_development_scans TO intel;
+GRANT SELECT ON full_intel TO intel;
+GRANT SELECT ON planet_tags TO intel;
+GRANT SELECT ON available_planet_tags TO intel;
+
+GRANT EXECUTE ON FUNCTION coords(int,int,int) TO intel;
+GRANT EXECUTE ON FUNCTION planetcoords(int,int) TO intel;
+GRANT EXECUTE ON FUNCTION planetid(int,int,int,int) TO intel;
+GRANT EXECUTE ON FUNCTION tick() TO intel;
+GRANT EXECUTE ON FUNCTION endtick() TO intel;
+
+ALTER FUNCTION tick() SECURITY DEFINER;
+ALTER FUNCTION endtick() SECURITY DEFINER;