Hi there I want to give a user permission to the report designer yet still restrict their access to sensitive data such as the General ledger etc therefore I can’t give them a super user role, any ideas? Thanks in advance Derek
Give him the rights for the reports, but if the user do not have the rights to read/modify the tables, than user can not run the reports based on those table. so restrict the users by not giving him the table permissions.
HI Naveenjain I actually want to give the user rights to the object designer rather than to run reports. Derek
Well, still if the user do not have rights for the resticted tables, than even if he builds the report for those tables, he/she can not run the reports because report is using tables, which is not permitted to this user.
Permission to Object Designer can be added to a role as type of “System” permission. If my memory serves correctly it does respect all table data restrictions for a given user.
Hi Naveen You are correct. Derek - look in the standard “ALL” role - in the permissions you will see some “System” permissions, under here you can locate ID 5210 Tools, Object Designer. Whether you have this permission or not dictates the opening of Object Designer from the main menu.