Total Knowledge Projects Jobs Clientele Contact

UU Database

Personal tools
From Total Knowledge
(Difference between revisions)
Jump to: navigation, search
(Structure Requirements)
</OL>
</OL>
 +
 +
== Security Requirements ==
 +
 +
<LI> The security policy should provide several access roles. Besides the role, every user is granted the set of the (objects,projects,courses) he can access. Modification of access to the critical objects is only allowed if person has relation to the (objects,projects,courses).
 +
Every user may be granted several roles, if underlying database supports that.
 +
 +
<LI>
 +
We have to implement at least the following database roles:
 +
 +
1) DBO/DBA and backup (already implemented)
 +
2) Customer service = access to read everything (may be but security tables), access to all maintenance and all security stored procs
 +
3) Teacher = full access to any data within the course he is teaching (multiple courses per teacher are expected), access to data maintenance and user privileges stored procs within the course
 +
4) Student = some access (needs to be determined) to data maintenance within the course
 +
5) Reports = read access to everything but security tables, access to reporting stored procs
 +
 +
Automated maintenance should use either "Customer Service", or "Backup" roles..

Revision as of 08:33, 13 April 2006