set default report permission based on read
diff --git a/patches/january_2013/give_report_permission_on_read.py b/patches/january_2013/give_report_permission_on_read.py
new file mode 100644
index 0000000..d9496fb
--- /dev/null
+++ b/patches/january_2013/give_report_permission_on_read.py
@@ -0,0 +1,4 @@
+import webnotes
+def execute():
+ webnotes.conn.sql("""update tabDocPerm set `report`=`read`
+ where ifnull(permlevel,0)=0""")
diff --git a/patches/january_2013/report_permission.py b/patches/january_2013/report_permission.py
index 1465352..8f90e87 100644
--- a/patches/january_2013/report_permission.py
+++ b/patches/january_2013/report_permission.py
@@ -1,7 +1,7 @@
import webnotes
def execute():
webnotes.reload_doc("core", "doctype", "docperm")
- webnotes.conn.sql("""update tabDocPerm set `report`=`write`""")
+ webnotes.conn.sql("""update tabDocPerm set `report`=`read`""")
# no report for singles
webnotes.conn.sql("""update tabDocPerm, tabDocType set tabDocPerm.`report`=0
diff --git a/patches/patch_list.py b/patches/patch_list.py
index 52e1b02..4d3c780 100644
--- a/patches/patch_list.py
+++ b/patches/patch_list.py
@@ -586,4 +586,8 @@
'patch_module': 'patches.january_2013',
'patch_file': 'report_permission',
},
+ {
+ 'patch_module': 'patches.january_2013',
+ 'patch_file': 'give_report_permission_on_read',
+ },
]
\ No newline at end of file