Re: [rt-users] RT setup and Postgres object ownership

2012-11-27 Thread k...@rice.edu
Hi Darren, You can grant access using roles in PostgreSQL. So even though the DB is owned by postgres, your configured rt user can still access the data. Cheers, Ken On Mon, Nov 26, 2012 at 03:50:58PM -0700, Darren Spruell wrote: Recent user of RT on PostgreSQL backend (a couple of years on

[rt-users] RT setup and Postgres object ownership

2012-11-26 Thread Darren Spruell
Recent user of RT on PostgreSQL backend (a couple of years on MySQL) and have been struggling to understand something related to DB access privileges under postgres with RT's setup. I don't understand how the default ownership/rights after the RT setup, done using the postgres superuser (DBA),

Re: [rt-users] RT setup and Postgres object ownership

2012-11-26 Thread Thomas Sibley
On 11/26/2012 02:50 PM, Darren Spruell wrote: I don't understand how the default ownership/rights after the RT setup, done using the postgres superuser (DBA), allow the RT user to have read/write access to RT objects. RT runs the etc/acl.Pg file during install and etc/upgrade/*/acl.Pg during