diff options
| author | cvs2git <cvs2git> | 2010-12-27 00:04:45 +0000 |
|---|---|---|
| committer | cvs2git <cvs2git> | 2010-12-27 00:04:45 +0000 |
| commit | c82d349f864e6bd9f96fd1156903bc1f7193a203 (patch) | |
| tree | e117a87533656110b6acd56fc0ca64289892a9f5 /rt/etc/acl.Pg | |
| parent | 74e058c8a010ef6feb539248a550d0bb169c1e94 (diff) | |
This commit was manufactured by cvs2svn to create tag 'TORRUS_1_0_9'.TORRUS_1_0_9
Diffstat (limited to 'rt/etc/acl.Pg')
| -rwxr-xr-x | rt/etc/acl.Pg | 63 |
1 files changed, 0 insertions, 63 deletions
diff --git a/rt/etc/acl.Pg b/rt/etc/acl.Pg deleted file mode 100755 index 16ea71b2d..000000000 --- a/rt/etc/acl.Pg +++ /dev/null @@ -1,63 +0,0 @@ -sub acl { - my $dbh = shift; - - my @acls; - - my @tables = qw ( - - attachments_id_seq - Attachments - queues_id_seq - Queues - links_id_seq - Links - principals_id_seq - Principals - groups_id_seq - Groups - scripconditions_id_seq - ScripConditions - transactions_id_seq - Transactions - scrips_id_seq - Scrips - acl_id_seq - ACL - groupmembers_id_seq - GroupMembers - cachedgroupmembers_id_seq - CachedGroupMembers - users_id_seq - Users - tickets_id_seq - Tickets - scripactions_id_seq - ScripActions - templates_id_seq - Templates - ticketcustomfieldvalues_id_s - TicketCustomFieldValues - customfields_id_seq - CustomFields - customfieldvalues_id_seq - CustomFieldValues - sessions - ); - - # if there's already an rt_user, drop it. - my @row = - $dbh->selectrow_array( "select usename from pg_user where usename = '" . $RT::DatabaseUser."'" ); - if ( $row[0] ) { - push @acls, "drop user ${RT::DatabaseUser};",; - } - - push @acls, "create user ${RT::DatabaseUser} with password '${RT::DatabasePassword}' NOCREATEDB NOCREATEUSER;"; - foreach my $table (@tables) { - push @acls, - "GRANT SELECT, INSERT, UPDATE, DELETE ON $table to " - . $RT::DatabaseUser . ";"; - - } - return (@acls); -} -1; |