Permission in SQL server

NizarNizar Member Posts: 61
Hello,

I have upgradted my database to Navision 4SP1 SQL server.
With Navision i give to all user of badatdase the role "SUPER" but when someone try to modify any object like report, he can't.
I think i must modify some param in SQL server but i dont know how to do it.

Can anyone help me.
Thanks.

Comments

  • HalMdyHalMdy Member Posts: 429
    Have you checked also that the licence permits this kind of operation ? in other words, do you have a developper licence or the granule "Report designer" for the user ?
  • NizarNizar Member Posts: 61
    yes i have a developper licence
  • kinekine Member Posts: 12,562
    1) Do not forget to run the Synchronize after you change the permissions.
    2) Developers must be db_owner on the database (to be able to change table definitions etc.)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.