Capability Admin Sekolah

 mysql -u root -p

USE moodle2;
SELECT id, name, shortname FROM mdl_role WHERE shortname = 'adminsekolah';

cek capability
SELECT capability FROM mdl_role_capabilities
WHERE roleid = (SELECT id FROM mdl_role WHERE shortname = 'adminsekolah');

MariaDB [moodle2]> SELECT capability FROM mdl_role_capabilities
    -> WHERE roleid = (SELECT id FROM mdl_role WHERE shortname = 'adminsekolah');
+---------------------------------+
| capability                      |
+---------------------------------+
| enrol/manual:enrol              |
| enrol/manual:manage             |
| enrol/manual:unenrol            |
| moodle/category:manage          |
| moodle/course:changecategory    |
| moodle/course:changefullname    |
| moodle/course:changeidnumber    |
| moodle/course:changeshortname   |
| moodle/course:create            |
| moodle/course:manageactivities  |
| moodle/course:update            |
| moodle/course:view              |
| moodle/course:viewhiddencourses |
| moodle/course:visibility        |
| moodle/grade:edit               |
| moodle/grade:viewall            |
| moodle/site:viewreports         |
| moodle/user:changeownpassword   |
| moodle/user:create              |
| moodle/user:editprofile         |
| moodle/user:update              |
| moodle/user:viewdetails         |
| report/log:viewtoday            |
+---------------------------------+
23 rows in set (0.001 sec)