Showing related tags and posts across the entire site.
-
Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:"";...
-
Try making the user a member of the securityadmin fixed SERVER role. For versions prior to 4.0, adding a new Windows Login results in the following SQL calls: sp_grantlogin sp_grantdbaccess sp_grantlogin requires that the user is a member of either the sysadmin or securityadmin fixed SERVER roles. sp_grantdbaccess...
-
Interested to hear that you moved security to the users. We have taken the opposite route and retained responsibility for security within IT. What was the primary reason for moving the security roles? By the way have you a result for the SQL admin conumdrum?
-
I have the same situation and its work. My user is an SQL Login and have only the SecurityAdmin, and is db_owner in the Navision DB. Good luck