Index: openacs-4/packages/acs-kernel/sql/oracle/acs-objects-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/acs-objects-create.sql,v diff -u -r1.13 -r1.14 --- openacs-4/packages/acs-kernel/sql/oracle/acs-objects-create.sql 6 Jan 2004 15:54:28 -0000 1.13 +++ openacs-4/packages/acs-kernel/sql/oracle/acs-objects-create.sql 25 Jan 2004 01:25:47 -0000 1.14 @@ -536,9 +536,12 @@ -- sourced. We need to clean up the creates and once that is done -- we can turn this into a simple delete statement. -- - execute immediate 'delete from acs_permissions where object_id = :object_id or grantee_id = :object_id' + execute immediate 'delete from acs_permissions where object_id = :object_id' using in object_id; + execute immediate 'delete from acs_permissions where grantee_id = :object_id' + using in object_id; + for object_type in (select table_name, id_column from acs_object_types