/usr/share/gmod/chado/bin/privileges.tmpl is in chado-utils 1.31-3.
This file is owned by root:root, with mode 0o755.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | --create sql to grant permissions on tables in the database
-- sqlt -f PostgreSQL -t TTSchema --template bin/privileges.tmpl modules/nofuncs.sql>privileges.sql
--
--after it is created, the permissions can be updated by excuting this command:
--
-- $ cat privileges.sql | psql <databasename>
--
--since this opens up the database to all users, it should be used with
--caution. Another option would be to change "PUBLIC" below to a
--specific user or group to whom you want to grant privileges, or
--change the "ALL" to something more restrictive, like "SELECT."
[% FOREACH table IN schema.get_tables %]
GRANT ALL ON TABLE [% table.name %] TO PUBLIC;
[% END %]
|