Database activity module permissions
Roles and capabilities in Moodle 1.7 onwards enable possibilities such as students being given permission to manage database entries. The following capabilities are related to database activities:
Preventing students from adding entries
An override may be used to close/archive a database activity, or have a database in which only teachers can add entries, but students can view the entries.
- Access the Assign roles page via the Roles tab in editing database page, then follow the "Override roles" link. (In Moodle 1.9 onwards, click the "Override permissions" tab in the editing database page.)
- Select the Student role.
- Set the capability mod/data:writeentry to prevent.
- Click the "Save changes" button.
Note: By default, only administrators are able to override permissions. Instructions on enabling teachers to override permissions can be found in Override permissions.
- Using Moodle Assign roles in database activity module forum discussion