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

[Ruslan Zakirov]

On Wed, Dec 3, 2008 at 4:21 AM, Aleksey Tsalolikhin
<atsaloli.tech at gmail.com> wrote:
> 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"
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: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>



-- 
Best regards, Ruslan.