-- PL/SQL to set up permissions/privileges for photo-album
--
-- author: Tom Baginski, bags@arsdigita.com
-- creation date: 12/12/2000
--
-- $Id: permissions.sql,v 1.1 2002/07/09 17:35:10 rmello Exp $

-- uses standard read, write, delete, and admin 
-- for most permission checks.
--
-- Added custom create privileges so that creation
-- of folders, albums, and photos can be controlled
-- independantly.  Allows one user to control folder
-- structure while other users add albums and photos

select acs_privilege__create_privilege('pa_create_album', null, null);
select acs_privilege__create_privilege('pa_create_folder', null, null);
select acs_privilege__create_privilege('pa_create_photo', null, null);

select acs_privilege__add_child('create', 'pa_create_photo');
select acs_privilege__add_child('create', 'pa_create_album');
select acs_privilege__add_child('create', 'pa_create_folder');