On Tue, Dec 2, 2008 at 5:04 PM, Glenn Sieb <[EMAIL PROTECTED]> wrote: > > rt_user should have *all* permissions on the tables--it is, after all, > the user controlling the database.
Thanks, Glenn. Here is what I ran. Did I miss anything? I tried putting in CREATE as Ruslan suggested but had to take it out as Postgres said "ERROR: invalid privilege type CREATE for table" So here is what I did run: \connect rt3; GRANT SELECT, UPDATE, DELETE on attachments_id_seq TO rt_user; GRANT SELECT, UPDATE, DELETE on Attachments TO rt_user; GRANT SELECT, UPDATE, DELETE on Attributes TO rt_user; GRANT SELECT, UPDATE, DELETE on attributes_id_seq TO rt_user; GRANT SELECT, UPDATE, DELETE on queues_id_seq TO rt_user; GRANT SELECT, UPDATE, DELETE on Queues TO rt_user; GRANT SELECT, UPDATE, DELETE on links_id_seq TO rt_user; GRANT SELECT, UPDATE, DELETE on Links TO rt_user; GRANT SELECT, UPDATE, DELETE on principals_id_seq TO rt_user; GRANT SELECT, UPDATE, DELETE on Principals TO rt_user; GRANT SELECT, UPDATE, DELETE on groups_id_seq TO rt_user; GRANT SELECT, UPDATE, DELETE on Groups TO rt_user; GRANT SELECT, UPDATE, DELETE on scripconditions_id_seq TO rt_user; GRANT SELECT, UPDATE, DELETE on ScripConditions TO rt_user; GRANT SELECT, UPDATE, DELETE on transactions_id_seq TO rt_user; GRANT SELECT, UPDATE, DELETE on Transactions TO rt_user; GRANT SELECT, UPDATE, DELETE on scrips_id_seq TO rt_user; GRANT SELECT, UPDATE, DELETE on Scrips TO rt_user; GRANT SELECT, UPDATE, DELETE on acl_id_seq TO rt_user; GRANT SELECT, UPDATE, DELETE on ACL TO rt_user; GRANT SELECT, UPDATE, DELETE on groupmembers_id_seq TO rt_user; GRANT SELECT, UPDATE, DELETE on GroupMembers TO rt_user; GRANT SELECT, UPDATE, DELETE on cachedgroupmembers_id_seq TO rt_user; GRANT SELECT, UPDATE, DELETE on CachedGroupMembers TO rt_user; GRANT SELECT, UPDATE, DELETE on users_id_seq TO rt_user; GRANT SELECT, UPDATE, DELETE on Users TO rt_user; GRANT SELECT, UPDATE, DELETE on tickets_id_seq TO rt_user; GRANT SELECT, UPDATE, DELETE on Tickets TO rt_user; GRANT SELECT, UPDATE, DELETE on scripactions_id_seq TO rt_user; GRANT SELECT, UPDATE, DELETE on ScripActions TO rt_user; GRANT SELECT, UPDATE, DELETE on templates_id_seq TO rt_user; GRANT SELECT, UPDATE, DELETE on Templates TO rt_user; GRANT SELECT, UPDATE, DELETE on objectcustomfieldvalues_id_s TO rt_user; GRANT SELECT, UPDATE, DELETE on ObjectCustomFieldValues TO rt_user; GRANT SELECT, UPDATE, DELETE on customfields_id_seq TO rt_user; GRANT SELECT, UPDATE, DELETE on CustomFields TO rt_user; GRANT SELECT, UPDATE, DELETE on objectcustomfields_id_s TO rt_user; GRANT SELECT, UPDATE, DELETE on ObjectCustomFields TO rt_user; GRANT SELECT, UPDATE, DELETE on customfieldvalues_id_seq TO rt_user; GRANT SELECT, UPDATE, DELETE on CustomFieldValues TO rt_user; GRANT SELECT, UPDATE, DELETE on sessions TO rt_user; Thanks, Aleksey _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
