User Tools

Site Tools


schema_0_9_10_grants

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Last revision Both sides next revision
schema_0_9_10_grants [2008/11/08 18:23]
daniel
schema_0_9_10_grants [2008/11/08 18:55]
daniel
Line 9: Line 9:
   * Users are assigned to groups with //GRANT role TO user// commands.   * Users are assigned to groups with //GRANT role TO user// commands.
  
 +==== Script for tables and sequences ====
 Here is a skeleton of an SQL script that grants all rights to the ''​mailusers''​ group. The administrator can use this as a starting point and remove specific access rights to particular groups of users. Here is a skeleton of an SQL script that grants all rights to the ''​mailusers''​ group. The administrator can use this as a starting point and remove specific access rights to particular groups of users.
 <code sql> <code sql>
Line 50: Line 51:
  
 </​code>​ </​code>​
 +
 +==== Functions ====
 +Special care must be taken with functions since the execute privilege is granted to PUBLIC (every user) by default. In order to restrict the rights to use functions, the administrator should first revoke that privilege:
 +<code sql>
 +REVOKE EXECUTE ON FUNCTION
 + ​trash_msg(int,​ int),
 + ​trash_msg_set(int[],​ int),
 + ​untrash_msg(int,​ int),
 + ​delete_msg(int),​
 + ​delete_msg_set(int[])
 +FROM public;
 +</​code>​
 +
 +It is especially interesting to remove the right to call delete_msg() on all or specific users to prevent accidental deletion of messages when the local policy it to never delete any mail.
  
schema_0_9_10_grants.txt ยท Last modified: 2008/11/08 19:02 by daniel