20 scripconditions_id_seq
30 cachedgroupmembers_id_seq
40 objectcustomfieldvalues_id_s
41 ObjectCustomFieldValues
44 objectcustomfields_id_s
46 customfieldvalues_id_seq
51 # if there's already an rt_user, drop it.
53 $dbh->selectrow_array( "select usename from pg_user where usename = '" . $RT::DatabaseUser."'" );
55 push @acls, "drop user ${RT::DatabaseUser};",;
58 push @acls, "create user ${RT::DatabaseUser} with password '${RT::DatabasePassword}' NOCREATEDB NOCREATEUSER;";
59 foreach my $table (@tables) {
61 "GRANT SELECT, INSERT, UPDATE, DELETE ON $table to "
62 . $RT::DatabaseUser . ";";