Hi, I have a problem with designer rights in the SQL version. I have the form, table, report & dataport designer. All the designer granules are in the license file which is uploaded to the server. Anyhow for every modification attempt I am denied access to perform changes or create new items. I use Windows Authentication on a 2003 server platform. My login account is assigned to a role as super user. I would be grateful for any suggestions. Ole Schjoeth, SOMS
Hi, - Are the granules “Application Builder” and “Solution Developer” included in the license? - Are you trying to change posted documents or ledger tables (“G/L Entry”, “Sales Invoice Header”, etc.)?
Hi Nelson and thanks 
No, there is no Application Builder nor Solution Developer included in the license. Regarding Design it contains the following granules: 7,110 Report & Dataport Designer 1 7,120 Form Designer 1 7,130 Table Designer 1 However, we can’t even change the font size on a label on a form! Regards, Ole
What error message are you receiving? Django
Hi Django! If I try to add field #51000 to the Customer Table and save the message is: You do not have read permission for the ‘Cust. Ledger Entry’ Table. If I modify a label on a form the message is: You do not have permission to modify the ‘Contact Card’ Form. If I try to create a dataport based on table #7 the message is: You do not have permission to create the ‘Test’ dataport. This seems weird to me as I have uploaded the license file with the right granules and I am assigned to the super user role through my Windows login!?!
Try deleting your .zup file. Sounds like somethings really wonky. Django
Tried deleting the .zup file but no luck! Do you know if the SQL server should be stopped and started when updating the Navison license file?
My understanding was that wasn’t required. However you Upload your license to the server. You could also try to Change to your license since that should override the server license until you shutdown the client. It can’t hurt to stop and start the server however… Otherwise I’m at a loss… 
Django
Hi Ole (am I going crazy or did you just update your user name?!? [B)] [:D]), You could setup a Database User with the SUPER role and test with that new user. Also, check to make sure the SUPER role has not been changed and in fact includes the full permission set. One last thing, what about the object/field ranges that your license is configured for? There should be a file listing the license’s allowed ranges.
Oh - not stumped yet. Try logging on as a local Administrator. I had one client who couldn’t compile any modifications unless they were logged in as Administrator. Never figured out why - perhpas a corrupt NT profile…? Django
Well, we’ve tried just about everything but no luck so far. License file is ok, so it seems! But as a super user I am not even allowed to change font size on a text label on e.g. the customer form.
These sound like Security Setup Issues:
quote:
Originally posted by oleschjoeth
…If I try to add field #51000 to the Customer Table and save the message is: You do not have read permission for the ‘Cust. Ledger Entry’ Table…
This message is because the Customer Table is given permission to the Customer Ledger Entry Table. You will not be able to modify this table without permission to Read this Table for your User (not Indirect).
quote:
Originally posted by oleschjoeth
…If I modify a label on a form the message is: You do not have permission to modify the ‘Contact Card’ Form…
Your User MUST be assigned Form Modify Permissions
- Are you dbo @ SQL ? Seems like youre not. 2. You also might have a problem with Cronus licence files that have expired. Try replacing it with your own licence under cronus name. Tõnu
Thanks to everybody! You can stop searching! I found the explanation! The reason was simple. When a super user role is assigned to a company within the Navision/SQL database he/she can no longer make create or modify objects before these are global and common for all companies within the database. The solution is not to assign the super user to a specific company! Simple, but one could have hoped for some kind of warning / error message from the system [8D]
At least one user must be assigned SUPER rights for all companies. You must have had another user already assigned this privilege or you would have received the error message. After you have that one user fulfilling this condition, the system can no longer “guess” if you’re commiting a mistake or doing what you actually want…