diff options
| author | Michele Simionato <michele.simionato@gmail.com> | 2014-07-29 11:57:01 +0200 |
|---|---|---|
| committer | Michele Simionato <michele.simionato@gmail.com> | 2014-07-29 11:57:01 +0200 |
| commit | 807443ef3d043565a00ba475aa8d132006304b77 (patch) | |
| tree | e8e2b4a22bc75da4c67c708e91185f2610eeacc7 /sqlplain/doc/grant_perm.py | |
| parent | 90ecdcfcdb3fb64d6f5db609a97d9c18d54652ee (diff) | |
| download | micheles-master.tar.gz | |
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) |