Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

客户关系管理
e-Commerce
会计
库存
PoS
项目
MRP

All apps

所有帖文人徽章

标签（查看所有）

odoo accounting v14 pos v15

关于此论坛区

帮助

Unable to export all leads on user login.

1 回复

4196 查看

divya

When i login through Admin all leads are exporting but, through user login when Export All Data of leads iam getting this error, please do the needful. i gave the sale/ manager rights to this user but no use,

2015-06-16 09:33:25,897 12031 INFO 12-june-2015 werkzeug: 127.0.0.1 - - [16/Jun/2015 09:33:25] "POST /web/export/namelist HTTP/1.1" 200 -

2015-06-16 09:33:27,686 12031 WARNING 12-june-2015 openerp.osv.orm: Access Denied by record rules for operation: read, uid: 33, model: res.users

2015-06-16 09:33:27,687 12031 INFO 12-june-2015 openerp.osv.orm: Prefetching attempt for fields ['menu_id', 'alias_id', 'share', 'default_section_id', 'active', 'password', 'partner_id', 'id', 'login_date', 'company_id', 'signature', 'login', 'action_id', 'ean13', 'alias_defaults', 'x_technical_person', 'x_comment', 'display_name', 'opt_out', 'title', 'company_id', 'supdate', 'parent_id', 'last_reconciliation_date', 'employee', 'fax', 'lastname', 'x_other_phone', 'x_location', 'name', 'debit_limit', 'signup_token', 'db_server', 'additional_notes', 'street', 'payment_next_action_date', 'alias_name', u'x_nickname', 'country_id', 'notification_email_send', 'supplier', 'ref', 'email', 'picking_warn', 'street2', 'active', 'tz', 'signup_expiration', 'vat_subjected', 'zip', 'alias_user_id', 'x_sale_repo', 'payment_next_action', 'alias_model_id', 'payment_note', 'comment', 'sale_warn', 'purchase_warn', 'color', 'city', 'user_id', 'alias_force_thread_id', 'type', 'function', 'picking_warn_msg', 'phone', 'payment_responsible_id', 'customer', 'pacs', 'birthdate', 'cust_status', 'vat', 'state_id', 'invoice_warn_msg', 'website', 'remote_conn', 'use_parent_address', 'sale_warn_msg', 'signup_type', 'invoice_warn', 'x_department', 'is_company', 'sitelic', 'firstname', 'section_id', 'date', 'lang', 'credit_limit', 'purchase_warn_msg', 'mobile', 'x_location_name', 'x_work_phone'] on res.users failed for ids [1, 36, 37, 6, 33, 40, 39, 14, 22, 279, 25, 252], re-trying just for id 279

2015-06-16 09:33:27,891 12031 WARNING 12-june-2015 openerp.osv.orm: Access Denied by record rules for operation: read, uid: 33, model: res.partner

2015-06-16 09:33:27,891 12031 INFO 12-june-2015 openerp.osv.orm: Prefetching attempt for fields ['ean13', 'x_technical_person', 'x_comment', 'tz', 'opt_out', 'title', 'company_id', 'supdate', 'parent_id', 'last_reconciliation_date', u'x_nickname', 'employee', 'fax', 'lastname', 'supplier', 'name', 'debit_limit', 'signup_token', 'db_server', 'additional_notes', 'street', 'payment_next_action_date', 'firstname', 'country_id', 'notification_email_send', 'x_other_phone', 'x_location', 'ref', 'email', 'picking_warn', 'street2', 'mobile', 'active', 'display_name', 'signup_expiration', 'x_sale_repo', 'payment_next_action', 'payment_note', 'comment', 'sale_warn', 'purchase_warn', 'color', 'city', 'user_id', 'zip', 'type', 'function', 'picking_warn_msg', 'vat', 'phone', 'payment_responsible_id', 'customer', 'pacs', 'birthdate', 'cust_status', 'state_id', 'invoice_warn_msg', 'website', 'remote_conn', 'use_parent_address', 'signup_type', 'date', 'invoice_warn', 'x_department', 'is_company', 'sitelic', 'vat_subjected', 'section_id', 'lang', 'credit_limit', 'purchase_warn_msg', 'x_location_name', 'x_work_phone', 'sale_warn_msg'] on res.partner failed for ids [17888, 15936, 3, 1046, 5287, 5290, 5291, 12, 1005, 93, 5293, 15915, 16054, 15069], re-trying just for id 17888

2015-06-16 09:33:27,939 12031 WARNING 12-june-2015 openerp.osv.orm: Access Denied by record rules for operation: read, uid: 33, model: res.users

2015-06-16 09:33:27,940 12031 INFO 12-june-2015 openerp.osv.orm: Prefetching attempt for fields ['menu_id', 'alias_id', 'share', 'default_section_id', 'active', 'password', 'partner_id', 'id', 'login_date', 'company_id', 'signature', 'login', 'action_id', 'ean13', 'alias_defaults', 'x_technical_person', 'x_comment', 'display_name', 'opt_out', 'title', 'company_id', 'supdate', 'parent_id', 'last_reconciliation_date', 'employee', 'fax', 'lastname', 'x_other_phone', 'x_location', 'name', 'debit_limit', 'signup_token', 'db_server', 'additional_notes', 'street', 'payment_next_action_date', 'alias_name', u'x_nickname', 'country_id', 'notification_email_send', 'supplier', 'ref', 'email', 'picking_warn', 'street2', 'active', 'tz', 'signup_expiration', 'vat_subjected', 'zip', 'alias_user_id', 'x_sale_repo', 'payment_next_action', 'alias_model_id', 'payment_note', 'comment', 'sale_warn', 'purchase_warn', 'color', 'city', 'user_id', 'alias_force_thread_id', 'type', 'function', 'picking_warn_msg', 'phone', 'payment_responsible_id', 'customer', 'pacs', 'birthdate', 'cust_status', 'vat', 'state_id', 'invoice_warn_msg', 'website', 'remote_conn', 'use_parent_address', 'sale_warn_msg', 'signup_type', 'invoice_warn', 'x_department', 'is_company', 'sitelic', 'firstname', 'section_id', 'date', 'lang', 'credit_limit', 'purchase_warn_msg', 'mobile', 'x_location_name', 'x_work_phone'] on res.users failed for ids [1, 36, 37, 6, 33, 40, 39, 14, 22, 25, 252], re-trying just for id 252

2015-06-16 09:33:27,946 12031 WARNING 12-june-2015 openerp.osv.orm: Access Denied by record rules for operation: read, uid: 33, model: res.users

2015-06-16 09:33:27,948 12031 ERROR 12-june-2015 openerp.netsvc: Access Denied

The requested operation cannot be completed due to security restrictions. Please contact your system administrator.

(Document type: Users, Operation: read)

Traceback (most recent call last):

File "/home/endo/Openerp_v7/openerp/netsvc.py", line 296, in dispatch_rpc

result = ExportService.getService(service_name).dispatch(method, params)

File "/home/endo/Openerp_v7/openerp/service/web_services.py", line 626, in dispatch

res = fn(db, uid, *params)

File "/home/endo/Openerp_v7/openerp/osv/osv.py", line 190, in execute_kw

return self.execute(db, uid, obj, method, *args, **kw or {})

File "/home/endo/Openerp_v7/openerp/osv/osv.py", line 132, in wrapper

return f(self, dbname, *args, **kwargs)

File "/home/endo/Openerp_v7/openerp/osv/osv.py", line 199, in execute

res = self.execute_cr(cr, uid, obj, method, *args, **kw)

File "/home/endo/Openerp_v7/openerp/osv/osv.py", line 187, in execute_cr

return getattr(object, method)(cr, uid, *args, **kw)

File "/home/endo/Openerp_v7/openerp/osv/orm.py", line 1248, in export_data

datas += self.__export_row(cr, uid, row, fields_to_export, context)

File "/home/endo/Openerp_v7/openerp/osv/orm.py", line 1165, in __export_row

r = r[f[i]]

File "/home/endo/Openerp_v7/openerp/osv/orm.py", line 412, in __getitem__

field_values = self._table.read(self._cr, self._uid, ids, field_names, context=self._context, load="_classic_write")

File "/home/endo/Openerp_v7/openerp/addons/base/res/res_users.py", line 831, in read

res = super(users_view, self).read(cr, uid, ids, fields, context=context, load=load)

File "/home/endo/Openerp_v7/openerp/addons/base/res/res_users.py", line 292, in read

result = super(res_users, self).read(cr, uid, ids, fields=fields, context=context, load=load)

File "/home/endo/Openerp_v7/openerp/osv/orm.py", line 3679, in read

result = self._read_flat(cr, user, select, fields, context, load)

File "/home/endo/Openerp_v7/openerp/osv/orm.py", line 3734, in _read_flat

self._check_record_rules_result_count(cr, user, sub_ids, result_ids, 'read', context=context)

File "/home/endo/Openerp_v7/openerp/osv/orm.py", line 3938, in _check_record_rules_result_count

(self._description, operation))

except_osv: (u'Access Denied', u'The requested operation cannot be completed due to security restrictions. Please contact your system administrator.\n\n(Document type: Users, Operation: read)')

2015-06-16 09:33:27,950 12031 INFO 12-june-2015 werkzeug: 127.0.0.1 - - [16/Jun/2015 09:33:27] "POST /web/export/csv HTTP/1.1" 500 -

matt crouch

Your user does not have permission to access certain models. In particular, I notice an inability to read:

res.users

res.partner

You can correct this by increasing the permissions level of the user in at least two ways. First, you can add the user to a pre-made group which has the ability to read those models. In stock Odoo, this will be most groups - if you have the sale and crm modules installed, the group would be 'Sales: See all leads.' Second, you can find what groups the user is already in, and increase the permission level at the model level (worse approach). To do do, AS THE ADMINISTRATOR, go to settings -> technical -> database structure -> models, and search for res.partner and res.users (I am also assuming you have already enabled viewing the technical settings) .

Once you are looking at each model, there is a tab named 'access rights.' Here you can add new groups, or change permissions of existing groups so that they can read it. You will need to add a group that the user in question is already a member of in order for this to be effective.

喜欢讨论吗？不要只阅读，加入进来！

立即创建账户，享受专属功能，与我们的精彩社区互动！

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！