Tweet
Is there a way to give a user permission to design and run some Reports, but not all Reports? Furthermore, I’d like to Deny that same user permission to design Forms, Browses, Labels, Operations, and Codes? I’m using version 9, Desktop, with the most recent update. I’ve downloaded the trial copy of version 11, but get all the same errors.
I was very close to solving this problem, but hit a block. Here’s what I’ve been able to do so far: The user has permission to design only the Reports I specify, and they cannot alter any Forms, Browses, Labels, Operations, and Codes (That’s exactly how I want that user group to function). However, when the user runs a script that has an APPEND operation; the user gets an error that says
“You are not allowed to design append ‘ItDisplaysFilenameHere’. If you want permission to do so, please talk to your system administrator”.
You can click a button on the dialogue box called “Why?” It then says: “You were denied access to ‘ItDisplaysFilenameHere’ because you do not have the following permissions: "Design" append: ‘ItDisplaysFilenameHere’ ”
The error stops the script.
As I said, I was very close to solving this problem, but hit a block. Here’s what I’ve done so far:
I have 2 user groups and I assign the user to both groups:
1) CannotDesign
2) CanDesignGroup1
GLOBAL PERMISSIONS: I set the global security as follows (in the control panel I went to the Reports tab and right-clicked on the white space). I added the group called CannotDesign to the list. I set the permissions as Delete=Deny, Design=Deny, and Run=Blank. This Denies the user from Design on all Reports, Forms, Browses, Labels, Operations, and Codes. But allows the user to Run them all (My default permission in the security settings = Grant).
PERMISSIONS ON A SPECIFIC REPORT: For the report that I wanted the user to Design, I set the security as follows (in the control panel I right-clicked on the icon for the report). I added the group called CanDesignGroup1 to the list. I set the permissions as Delete=Blank, Design=GRANT, and Run=Blank. This GRANTS the user the permission to Design for only this report. So far this was great. That’s exactly how I wanted everything to work.
I then ran the script that creates the report. This script contains several COPY operations and an APPEND operation. I received an error like the one described above. The same error occurred at each COPY and APPEND operation. To fix this, I then went to the control panel, right-clicked on each operation icon, and set the permissions as I did for the report icon (i.e., added the group called CanDesignGroup1 to the list, and Design=GRANT). This worked great for the COPY operations, but not for the APPEND. This is where I’m stuck. Does anyone have a solution or thought?
Thanks in advance for helping me out.
I was very close to solving this problem, but hit a block. Here’s what I’ve been able to do so far: The user has permission to design only the Reports I specify, and they cannot alter any Forms, Browses, Labels, Operations, and Codes (That’s exactly how I want that user group to function). However, when the user runs a script that has an APPEND operation; the user gets an error that says
“You are not allowed to design append ‘ItDisplaysFilenameHere’. If you want permission to do so, please talk to your system administrator”.
You can click a button on the dialogue box called “Why?” It then says: “You were denied access to ‘ItDisplaysFilenameHere’ because you do not have the following permissions: "Design" append: ‘ItDisplaysFilenameHere’ ”
The error stops the script.
As I said, I was very close to solving this problem, but hit a block. Here’s what I’ve done so far:
I have 2 user groups and I assign the user to both groups:
1) CannotDesign
2) CanDesignGroup1
GLOBAL PERMISSIONS: I set the global security as follows (in the control panel I went to the Reports tab and right-clicked on the white space). I added the group called CannotDesign to the list. I set the permissions as Delete=Deny, Design=Deny, and Run=Blank. This Denies the user from Design on all Reports, Forms, Browses, Labels, Operations, and Codes. But allows the user to Run them all (My default permission in the security settings = Grant).
PERMISSIONS ON A SPECIFIC REPORT: For the report that I wanted the user to Design, I set the security as follows (in the control panel I right-clicked on the icon for the report). I added the group called CanDesignGroup1 to the list. I set the permissions as Delete=Blank, Design=GRANT, and Run=Blank. This GRANTS the user the permission to Design for only this report. So far this was great. That’s exactly how I wanted everything to work.
I then ran the script that creates the report. This script contains several COPY operations and an APPEND operation. I received an error like the one described above. The same error occurred at each COPY and APPEND operation. To fix this, I then went to the control panel, right-clicked on each operation icon, and set the permissions as I did for the report icon (i.e., added the group called CanDesignGroup1 to the list, and Design=GRANT). This worked great for the COPY operations, but not for the APPEND. This is where I’m stuck. Does anyone have a solution or thought?
Thanks in advance for helping me out.
Comment