diff options
| author | cvs2git <cvs2git> | 2008-03-16 19:58:34 +0000 |
|---|---|---|
| committer | cvs2git <cvs2git> | 2008-03-16 19:58:34 +0000 |
| commit | eb061f5119325e666f0dff40d4089e5c1df58e17 (patch) | |
| tree | d55e8fef5aca62eb13bbc8ad20dbdf941c3bd266 /rt/etc/acl.Pg | |
| parent | 3a17b276638200475d54201fa62566b7440e819a (diff) | |
This commit was manufactured by cvs2svn to create tag 'TRIXBOX_2_6'.TRIXBOX_2_6
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; |