[rt-users] installing RT with PostgreSQL yields "invalid privilege type USAGE for table" error

[Ruslan Zakirov]

On Wed, Dec 3, 2008 at 1:22 AM, Aleksey Tsalolikhin
<atsaloli.tech at gmail.com> wrote:
> Hi.  I just downloaded rt-3.8.1 and am trying to install in on CentOS
> 5.2 with PostgreSQL 8.1.11
>
> make initialize-database exists with error:
>
> Working with:
> Type:   Pg
> Host:   localhost
> Name:   rt3
> User:   rt_user
> DBA:    postgres
> Now creating a Pg database rt3 for RT.
> Done.
> Now populating database schema.
> Done.
> Now inserting database ACLs
> Couldn't finish 'acl' step.
>
> ERROR: Couldn't run SQL query:
>  GRANT USAGE, SELECT, UPDATE ON attachments_id_seq TO rt_user;

USAGE for sequences has been added in Pg 8.2. Replace "GRANT USAGE,
SELECT, UPDATE" with "GRANT SELECT, UPDATE" in etc/acl.Pg.

>
> ERROR: ERROR:  invalid privilege type USAGE for table
>
> make: *** [initialize-database] Error 255
> [root at hwd-ddc-app-prod01 rt-3.8.1]#
>
>
> So I re-ran this command as:
>
> rt3=# GRANT SELECT, UPDATE ON attachments_id_seq TO rt_user;
> GRANT
> rt3=#
>
> MySQL.com docs say "USAGE" is synonym for "no privileges".
>
> Does anybody know the PostgreSQL equivalent for "no priveleges", please?
>
> Best,
> Aleksey
>
> --
> Aleksey Tsalolikhin
> UNIX System Administrator
> "I get stuff done!"
> http://www.lifesurvives.com/
> _______________________________________________
> 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.