I set the security on our application with different priviledges and when they execute a query to produce a report it does not run. I found through TOOLS, SECURITY, USER AND GROUP PERMISSIONS that I can set BY GROUP or BY USER to give permission to OPEN/RUN and MODIFY DESIGN on the queries. I set it for the "full data users"and for the "new data users". At first it works in one of the "new data user", but I noticed that this permission was lost and had to set it again. I also tried setting the owner access "WITH OWNERACCESS OPTION" declaration in the SQL and it didn't work. What can I do to solve this situation?