sql user

subrata.bauri
subrata.bauri Member Posts: 21
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??????????

Comments

  • kine
    kine 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.
  • garak
    garak 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!
  • kriki
    kriki Member, Moderator Posts: 9,121
    [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!

Categories