sql user

subrata.baurisubrata.bauri Member Posts: 36
edited 2008-03-17 in SQL General
How can I stop the sql user to create a table in Navision, or insert/modify/delete table data??????????


  • kinekine Member Posts: 12,562
    By remoing the appropriate permissions to Table object type and DataTable type. And by removing db_owner from this user (it is not needed if permissions are set correctly).
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • garakgarak Member Posts: 3,263
    normal users should only hve the "public" permission on sql. Only administrators should have db_owner or administrator permission.
    Also be sure, that the users ar not "super" in navision (roles). Here give them the correct permissions by using roles (create new, test)
    Do you make it right, it works too!
  • krikikriki Member, Moderator Posts: 9,079
    [Topic moved from Navision Tips & Tricks to SQL General]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Sign In or Register to comment.