This file is indexed.

/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 %]