20 scripconditions_id_seq
32 cachedgroupmembers_id_seq
42 objectcustomfieldvalues_id_s
43 ObjectCustomFieldValues
46 objectcustomfields_id_s
48 customfieldvalues_id_seq
63 my $db_user = RT->Config->Get('DatabaseUser');
64 my $db_pass = RT->Config->Get('DatabasePassword');
66 # if there's already an rt_user, use it.
67 my @row = $dbh->selectrow_array( "SELECT usename FROM pg_user WHERE usename = '$db_user'" );
69 push @acls, "CREATE USER \"$db_user\" WITH PASSWORD '$db_pass' NOCREATEDB NOSUPERUSER;";
72 foreach my $table (@tables) {
73 if ( $table =~ /^[a-z]/ && $table ne 'sessions' ) {
74 # Sequences; not all end with _seq because
75 # objectcustomfieldvalues_id_s is too long
76 push @acls, "GRANT USAGE, SELECT, UPDATE ON $table TO \"$db_user\";"
79 push @acls, "GRANT SELECT, INSERT, UPDATE, DELETE ON $table TO \"$db_user\";"