summaryrefslogtreecommitdiff
path: root/sql/modules/Roles.sql
diff options
context:
space:
mode:
authoreinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-11-07 21:17:08 +0000
committereinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-11-07 21:17:08 +0000
commite9be327c853a73b7dbc517b9a63eff85444a3d7f (patch)
treefaa0e0dc8c8f6aa5c41ea6f24209dbc78809ede7 /sql/modules/Roles.sql
parentd877887c0268c23acad9785f2307a6f19f9c2b93 (diff)
Adding edit_drafts permission
Correcting logic in location_save Correcting data type contact_list Correcting some logic regarding how addresses are stored when they are modified. Adding relevant test cases. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2382 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'sql/modules/Roles.sql')
-rw-r--r--sql/modules/Roles.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/modules/Roles.sql b/sql/modules/Roles.sql
index ca8e2533..9ef3d4c7 100644
--- a/sql/modules/Roles.sql
+++ b/sql/modules/Roles.sql
@@ -1400,6 +1400,8 @@ GRANT ALL ON transactions, entity_employee, customer, vendor TO public;
GRANT ALL ON pending_job, payments_queue TO PUBLIC;
GRANT ALL ON pending_job_id_seq TO public;
--TODO, lock recurring, pending_job, payment_queue down more
+-- Roles with no db permissions:
+CREATE ROLE "lsmb_<?lsmb dbname ?>__draft_edit" WITH INHERIT NOLOGIN;
-- CT: The following grant is required for now, but will hopefully become less
-- important when we get to 1.4 and can more sensibly lock things down.