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;

ERROR: ERROR:  invalid privilege type USAGE for table

make: *** [initialize-database] Error 255
[EMAIL PROTECTED] 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: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Reply via email to