On Wed, Dec 3, 2008 at 4:21 AM, Aleksey Tsalolikhin <[EMAIL PROTECTED]> wrote: > 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" Sorry, it should be INSERT instead of CREATE.
> > 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 > -- Best regards, Ruslan. _______________________________________________ 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
