-- -----------------------------------------------------------------------------------------------------

-- "Ensemble" is the proprietary property of The Regents of the University of California ("The Regents.")
-- 
-- Copyright (c) 2005-10 The Regents of the University of California, Davis campus. All Rights Reserved.
--
-- Redistribution and use in source and binary forms, with or without modification, are permitted by 
-- nonprofit, research institutions for research use only, provided the conditions in the included
-- licence agreement are met. 
--
-- Refer to the file "ensemble_license.txt" for the license agreement,
-- located in the top level directory of this distribution.

-- -----------------------------------------------------------------------------------------------------

grant usage on *.* to `subject_account`@`mysql_hostname` identified by 'subject_password' with max_queries_per_hour 0 max_connections_per_hour 0 max_updates_per_hour 0 ;
grant select, insert, update on `db_name`.* to `subject_account`@`mysql_hostname`;
grant usage on *.* to `researcher_account`@`mysql_hostname` identified by 'researcher_password' with max_queries_per_hour 0 max_connections_per_hour 0 max_updates_per_hour 0 ;
grant select, insert, update, delete, create, references, index, alter, create temporary tables on `db_name`.* to `researcher_account`@`mysql_hostname`;
