I've managed to create the follow fine...

First Site,

Slave Site from the First one.

I am trying to create children websites from the Slave Site.

Heres the template settings I've been using.

The rule that you defined is based on "admin" sites.
So I suppose this "admin" site is the first one that you created.

The "children" website are the one that are attached to the "template site". Here "admin".

I'm still having access denied when creating the children websites why would this be?

I've **** out my database password and **.***.***.** out my server IP address.

Hopefully you can help me as to why I keep getting this error.

Error(1) [1142] query [CREATE OR REPLACE VIEW akgasideal_users AS SELECT * FROM `akgas_joomla`.`adm_users`]. DB Error: CREATE VIEW command denied to user 'akgas_joomla'@'localhost' for table 'akgasideal_users' SQL=CREATE OR REPLACE VIEW akgasideal_users AS SELECT * FROM `akgas_joomla`.`adm_users`
Create User error [1142]: Query = [GRANT ALL PRIVILEGES ON `akgas_joomla`.`adm_users` TO `akgas_joomla`@`**.***.***.**` IDENTIFIED BY '******' WITH GRANT OPTION;], DB Message = [GRANT,CREATE VIE command denied to user 'akgas_joomla'@'localhost' for table 'adm_users' SQL=GRANT ALL PRIVILEGES ON `akgas_joomla`.`adm_users` TO `akgas_joomla`@`**.***.***.**` IDENTIFIED BY '******' WITH GRANT OPTION;]
Error [1142] retrying query [CREATE OR REPLACE VIEW akgasideal_users AS SELECT * FROM `akgas_joomla`.`adm_users`]. DB Error: CREATE VIEW command denied to user 'akgas_joomla'@'localhost' for table 'akgasideal_users' SQL=CREATE OR REPLACE VIEW akgasideal_users AS SELECT * FROM `akgas_joomla`.`adm_users`
Error(1) [1142] query [CREATE OR REPLACE VIEW akgasideal_session AS SELECT * FROM `akgas_joomla`.`adm_session`]. DB Error: CREATE VIEW command denied to user 'akgas_joomla'@'localhost' for table 'akgasideal_session' SQL=CREATE OR REPLACE VIEW akgasideal_session AS SELECT * FROM `akgas_joomla`.`adm_session`
Create User error [1142]: Query = [GRANT ALL PRIVILEGES ON `akgas_joomla`.`adm_session` TO `akgas_joomla`@`**.***.***.**` IDENTIFIED BY '*******' WITH GRANT OPTION;], DB Message = [GRANT,CREATE VIE command denied to user 'akgas_joomla'@'localhost' for table 'adm_session' SQL=GRANT ALL PRIVILEGES ON `akgas_joomla`.`adm_session` TO `akgas_joomla`@`**.***.***.**` IDENTIFIED BY '******' WITH GRANT OPTION;]
Error [1142] retrying query [CREATE OR REPLACE VIEW akgasideal_session AS SELECT * FROM `akgas_joomla`.`adm_session`]. DB Error: CREATE VIEW command denied to user 'akgas_joomla'@'localhost' for table 'akgasideal_session' SQL=CREATE OR REPLACE VIEW akgasideal_session AS SELECT * FROM `akgas_joomla`.`adm_session`
Error(1) [1142] query [CREATE OR REPLACE VIEW akgasideal_core_acl_aro AS SELECT * FROM `akgas_joomla`.`adm_core_acl_aro`]. DB Error: CREATE VIEW command denied to user 'akgas_joomla'@'localhost' for table 'akgasideal_core_acl_aro' SQL=CREATE OR REPLACE VIEW akgasideal_core_acl_aro AS SELECT * FROM `akgas_joomla`.`adm_core_acl_aro`
Create User error [1142]: Query = [GRANT ALL PRIVILEGES ON `akgas_joomla`.`adm_core_acl_aro` TO `akgas_joomla`@`**.***.***.**` IDENTIFIED BY '******' WITH GRANT OPTION;], DB Message = [GRANT,CREATE VIE command denied to user 'akgas_joomla'@'localhost' for table 'adm_core_acl_aro' SQL=GRANT ALL PRIVILEGES ON `akgas_joomla`.`adm_core_acl_aro` TO `akgas_joomla`@`**.***.***.**` IDENTIFIED BY '******' WITH GRANT OPTION;]
Error [1142] retrying query [CREATE OR REPLACE VIEW akgasideal_core_acl_aro AS SELECT * FROM `akgas_joomla`.`adm_core_acl_aro`]. DB Error: CREATE VIEW command denied to user 'akgas_joomla'@'localhost' for table 'akgasideal_core_acl_aro' SQL=CREATE OR REPLACE VIEW akgasideal_core_acl_aro AS SELECT * FROM `akgas_joomla`.`adm_core_acl_aro`
Error(1) [1142] query [CREATE OR REPLACE VIEW akgasideal_core_acl_aro_groups AS SELECT * FROM `akgas_joomla`.`adm_core_acl_aro_groups`]. DB Error: CREATE VIEW command denied to user 'akgas_joomla'@'localhost' for table 'akgasideal_core_acl_aro_groups' SQL=CREATE OR REPLACE VIEW akgasideal_core_acl_aro_groups AS SELECT * FROM `akgas_joomla`.`adm_core_acl_aro_groups`
Create User error [1142]: Query = [GRANT ALL PRIVILEGES ON `akgas_joomla`.`adm_core_acl_aro_groups` TO `akgas_joomla`@`**.***.***.**` IDENTIFIED BY '******' WITH GRANT OPTION;], DB Message = [GRANT,CREATE VIE command denied to user 'akgas_joomla'@'localhost' for table 'adm_core_acl_aro_groups' SQL=GRANT ALL PRIVILEGES ON `akgas_joomla`.`adm_core_acl_aro_groups` TO `akgas_joomla`@`**.***.***.**` IDENTIFIED BY '******' WITH GRANT OPTION;]
Error [1142] retrying query [CREATE OR REPLACE VIEW akgasideal_core_acl_aro_groups AS SELECT * FROM `akgas_joomla`.`adm_core_acl_aro_groups`]. DB Error: CREATE VIEW command denied to user 'akgas_joomla'@'localhost' for table 'akgasideal_core_acl_aro_groups' SQL=CREATE OR REPLACE VIEW akgasideal_core_acl_aro_groups AS SELECT * FROM `akgas_joomla`.`adm_core_acl_aro_groups`
Error(1) [1142] query [CREATE OR REPLACE VIEW akgasideal_core_acl_aro_map AS SELECT * FROM `akgas_joomla`.`adm_core_acl_aro_map`]. DB Error: CREATE VIEW command denied to user 'akgas_joomla'@'localhost' for table 'akgasideal_core_acl_aro_map' SQL=CREATE OR REPLACE VIEW akgasideal_core_acl_aro_map AS SELECT * FROM `akgas_joomla`.`adm_core_acl_aro_map`
Create User error [1142]: Query = [GRANT ALL PRIVILEGES ON `akgas_joomla`.`adm_core_acl_aro_map` TO `akgas_joomla`@`**.***.***.**` IDENTIFIED BY '******' WITH GRANT OPTION;], DB Message = [GRANT,CREATE VIE command denied to user 'akgas_joomla'@'localhost' for table 'adm_core_acl_aro_map' SQL=GRANT ALL PRIVILEGES ON `akgas_joomla`.`adm_core_acl_aro_map` TO `akgas_joomla`@`**.***.***.**` IDENTIFIED BY '******' WITH GRANT OPTION;]
Error [1142] retrying query [CREATE OR REPLACE VIEW akgasideal_core_acl_aro_map AS SELECT * FROM `akgas_joomla`.`adm_core_acl_aro_map`]. DB Error: CREATE VIEW command denied to user 'akgas_joomla'@'localhost' for table 'akgasideal_core_acl_aro_map' SQL=CREATE OR REPLACE VIEW akgasideal_core_acl_aro_map AS SELECT * FROM `akgas_joomla`.`adm_core_acl_aro_map`
Error(1) [1142] query [CREATE OR REPLACE VIEW akgasideal_core_acl_aro_sections AS SELECT * FROM `akgas_joomla`.`adm_core_acl_aro_sections`]. DB Error: CREATE VIEW command denied to user 'akgas_joomla'@'localhost' for table 'akgasideal_core_acl_aro_sections' SQL=CREATE OR REPLACE VIEW akgasideal_core_acl_aro_sections AS SELECT * FROM `akgas_joomla`.`adm_core_acl_aro_sections`
Create User error [1142]: Query = [GRANT ALL PRIVILEGES ON `akgas_joomla`.`adm_core_acl_aro_sections` TO `akgas_joomla`@`**.***.***.**` IDENTIFIED BY '******' WITH GRANT OPTION;], DB Message = [GRANT,CREATE VIE command denied to user 'akgas_joomla'@'localhost' for table 'adm_core_acl_aro_sections' SQL=GRANT ALL PRIVILEGES ON `akgas_joomla`.`adm_core_acl_aro_sections` TO `akgas_joomla`@`**.***.***.**` IDENTIFIED BY '******' WITH GRANT OPTION;]
Error [1142] retrying query [CREATE OR REPLACE VIEW akgasideal_core_acl_aro_sections AS SELECT * FROM `akgas_joomla`.`adm_core_acl_aro_sections`]. DB Error: CREATE VIEW command denied to user 'akgas_joomla'@'localhost' for table 'akgasideal_core_acl_aro_sections' SQL=CREATE OR REPLACE VIEW akgasideal_core_acl_aro_sections AS SELECT * FROM `akgas_joomla`.`adm_core_acl_aro_sections`
Error(1) [1142] query [CREATE OR REPLACE VIEW akgasideal_core_acl_groups_aro_map AS SELECT * FROM `akgas_joomla`.`adm_core_acl_groups_aro_map`]. DB Error: CREATE VIEW command denied to user 'akgas_joomla'@'localhost' for table 'akgasideal_core_acl_groups_aro_map' SQL=CREATE OR REPLACE VIEW akgasideal_core_acl_groups_aro_map AS SELECT * FROM `akgas_joomla`.`adm_core_acl_groups_aro_map`
Create User error [1142]: Query = [GRANT ALL PRIVILEGES ON `akgas_joomla`.`adm_core_acl_groups_aro_map` TO `akgas_joomla`@`**.***.***.**` IDENTIFIED BY '******' WITH GRANT OPTION;], DB Message = [GRANT,CREATE VIE command denied to user 'akgas_joomla'@'localhost' for table 'adm_core_acl_groups_aro_map' SQL=GRANT ALL PRIVILEGES ON `akgas_joomla`.`adm_core_acl_groups_aro_map` TO `akgas_joomla`@`**.***.***.**` IDENTIFIED BY '******' WITH GRANT OPTION;]
Error [1142] retrying query [CREATE OR REPLACE VIEW akgasideal_core_acl_groups_aro_map AS SELECT * FROM `akgas_joomla`.`adm_core_acl_groups_aro_map`]. DB Error: CREATE VIEW command denied to user 'akgas_joomla'@'localhost' for table 'akgasideal_core_acl_groups_aro_map' SQL=CREATE OR REPLACE VIEW akgasideal_core_acl_groups_aro_map AS SELECT * FROM `akgas_joomla`.`adm_core_acl_groups_aro_map`

Many thanks

Just read the error message
This is mentioned "command denied to user"

As you can read plenty of time in the forum, this mean that you MySQL user privileges does not have the permission to Create and show views.
So update your MySQL user privileges to accept create and show views.

If you are using a shared hosting, contact your hosting provider to ask him increase your mysql user privileges.

See also the video 0.b slide 35 that show how to increate the MySQL user privileges with PHPMyAdmin root login.
www.jms2win.com/en/tutorial#jms12x-0b