openrat-cms

commit e0c195604945cdafb3ae040ff2433b3112837e8d
parent e47fdbd731ede2235b5944ac51b8f90f9e7212d7
Author: dankert <devnull@localhost>
Date:   Sun,  2 May 2004 14:11:51 +0200

Initiale Version

Diffstat:
doc/database/sql/postgresql/grant.sql
 | 
23
+++++++++++++++++++++++

1 file changed, 23 insertions(+), 0 deletions(-)
diff --git a/doc/database/sql/postgresql/grant.sql b/doc/database/sql/postgresql/grant.sql
@@ -0,0 +1,22 @@
+-- Grant rights on all OpenRat tables 
+--
+-- Make sure to replace the word "username" with the real database username
+-- On MySql this grants are mostly unnecessary.
+
+GRANT SELECT,INSERT,UPDATE,DELETE ON or_acl           TO username;
+GRANT SELECT,INSERT,UPDATE,DELETE ON or_value         TO username;
+GRANT SELECT,INSERT,UPDATE,DELETE ON or_usergroup     TO username;
+GRANT SELECT,INSERT,UPDATE,DELETE ON or_templatemodel TO username;
+GRANT SELECT,INSERT,UPDATE,DELETE ON or_name          TO username;
+GRANT SELECT,INSERT,UPDATE,DELETE ON or_link          TO username;
+GRANT SELECT,INSERT,UPDATE,DELETE ON or_folder        TO username;
+GRANT SELECT,INSERT,UPDATE,DELETE ON or_file          TO username;
+GRANT SELECT,INSERT,UPDATE,DELETE ON or_element       TO username;
+GRANT SELECT,INSERT,UPDATE,DELETE ON or_projectmodel  TO username;
+GRANT SELECT,INSERT,UPDATE,DELETE ON or_page          TO username;
+GRANT SELECT,INSERT,UPDATE,DELETE ON or_language      TO username;
+GRANT SELECT,INSERT,UPDATE,DELETE ON or_template      TO username;
+GRANT SELECT,INSERT,UPDATE,DELETE ON or_object        TO username;
+GRANT SELECT,INSERT,UPDATE,DELETE ON or_group         TO username;
+GRANT SELECT,INSERT,UPDATE,DELETE ON or_user          TO username;
+GRANT SELECT,INSERT,UPDATE,DELETE ON or_project       TO username;+
\ No newline at end of file