diff options
Diffstat (limited to 'sqlplain/doc/grant_perm.py')
-rw-r--r-- | sqlplain/doc/grant_perm.py | 16 |
1 files changed, 0 insertions, 16 deletions
diff --git a/sqlplain/doc/grant_perm.py b/sqlplain/doc/grant_perm.py deleted file mode 100644 index 3695eba..0000000 --- a/sqlplain/doc/grant_perm.py +++ /dev/null @@ -1,16 +0,0 @@ -''' -$ grant_perm $DSN schema perm role -''' - -import sys -from sqlplain import connect, util - -if __name__ == '__main__': - try: - dsn, schema, perm, role = sys.argv[1:] - except ValueError: - sys.exit(__doc__) - db = connect(dsn) - for table in util.get_tables(db, 'public'): - db.execute('GRANT %s ON %s TO %s' % (perm, table, role)) - print 'Granted %s on %s to %s' % (perm, table, role) |