Total Knowledge Projects Jobs Clientele Contact

UU Database

Personal tools
From Total Knowledge
(Difference between revisions)
Jump to: navigation, search
(ACL implementation)
(ACL implementation)
<tr><td> Delete </td><td> 4 </td> <td> User may delete the object </td> </tr>
<tr><td> Delete </td><td> 4 </td> <td> User may delete the object </td> </tr>
<tr><td> Grant Access </td><td> 8 </td> <td> User may grant or change access to the object to other user(s) </td> </tr>
<tr><td> Grant Access </td><td> 8 </td> <td> User may grant or change access to the object to other user(s) </td> </tr>
-
<tr><td> Study </td><td> 16 </td> <td> User (student) may submit his answer or solution of the problem </td></tr>
+
<tr><td> Study </td><td> 16 </td> <td> User (student) may submit his answer or solution of the problem </td> <td> Proprietary Server only </td>  </tr>
-
<tr><td> Add Version </td><td> 32 </td> <td> User may create his own version of the object </td> </tr>
+
<tr><td> Add Version </td><td> 32 </td> <td> User may create his own version of the object </td> <td> Proprietary Server only </td>  </tr>
-
<tr><td> Add Translation </td><td> 64 </td> <td> User may create his own translated version of the object </td> <td>Not yet clear - to be discussed</td> </tr>
+
<tr><td> Add Translation </td><td> 64 </td> <td> User may create his own translated version of the object </td> <td> Proprietary Server only </td> </tr>
-
<tr><td> Reference </td> <td> 128 </td> <td> User may refer to this object in his objects </td> </tr>
+
<tr><td> Reference </td> <td> 128 </td> <td> User may refer to this object in his objects </td> <td> Proprietary Server only </td>  </tr>
</table>
</table>
ACL entries are maintained with the single stored procedure acl_set( table_name varchar(40), person int, access int ). Upon execution, stored procedure checks if the user has "Grant Access" right on the object, and if modifies the access for the person. If the required ACL entry doesn't exist it is created.
ACL entries are maintained with the single stored procedure acl_set( table_name varchar(40), person int, access int ). Upon execution, stored procedure checks if the user has "Grant Access" right on the object, and if modifies the access for the person. If the required ACL entry doesn't exist it is created.
 +
 +
ACL entries are performed slightly differently for the open server and proprietary server configurations. For the open server, the special right bits (Study..Reference) are always set, allowing unlimited Study..Reference use.
== Database objects ==
== Database objects ==

Revision as of 02:30, 30 September 2006