SF.net SVN: ledger-smb:[3634] trunk/tools/extract_role_grants.sh

[..hidden..]

Revision: 3634
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3634&view=rev
Author:   einhverfr
Date:     2011-08-04 21:21:08 +0000 (Thu, 04 Aug 2011)

Log Message:
-----------
Simple tool to extract role definitions and grants while not inserting menu acls

Added Paths:
-----------
    trunk/tools/extract_role_grants.sh

Added: trunk/tools/extract_role_grants.sh
===================================================================
--- trunk/tools/extract_role_grants.sh	                        (rev 0)
+++ trunk/tools/extract_role_grants.sh	2011-08-04 21:21:08 UTC (rev 3634)
@@ -0,0 +1,10 @@
+#!/bin/sh
+
+#This is a simple script which filters out the menu acl stuff from the Roles.sql
+#file and thus makes it suitable to run on systems with custom menues.
+#...
+# Standard usage would be something like:
+# sh tools/extract_role_grants.sh | sed -e 's/<?lsmb dbname ?>/[dbname]/' | psql#
+# This will eventually be moved into Perl in the Database.pm
+
+grep -iv "insert into" modules/Roles.sql | grep -iv values | less


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.