[rt-users] what's the username to log in? root/password does not work

Aleksey Tsalolikhin atsaloli.tech at gmail.com
Tue Dec 2 20:21:53 EST 2008


On Tue, Dec 2, 2008 at 5:04 PM, Glenn Sieb <ges at wingfoot.org> 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



More information about the rt-users mailing list