From 73119e806350719e2ce899bfbaa2ba19f0dc87d1 Mon Sep 17 00:00:00 2001 From: Michael Andreen Date: Sun, 27 Mar 2016 19:32:59 +0200 Subject: [PATCH] intel role --- database/dbaccess.sql | 36 ++++++++++++++++++++++++++++++++++++ 1 file changed, 36 insertions(+) create mode 100644 database/dbaccess.sql 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; -- 2.39.2