sql user

subrata.bauri

How can I stop the sql user to create a table in Navision, or insert/modify/delete table data??????????

kine

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).

garak

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)

kriki

[Topic moved from Navision Tips & Tricks to SQL General]