Database permissions

Moodle1.7

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:

• mod/data:viewrating
• mod/data:comment
• mod/data:writeentry
• mod/data:viewentry
• mod/data:rate
• mod/data:approve
• mod/data:manageentries
• mod/data:managecomments
• mod/data:managetemplates
• mod/data:viewalluserpresets
• mod/data:manageuserpresets

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.

1. 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.)
2. Select the Student role.
3. Set the capability mod/data:writeentry to prevent.
4. 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.

See also

• Using Moodle Assign roles in database activity module forum discussion