question

abhishek120684 avatar image
abhishek120684 asked

SQL Server Roles

Hi, I have a situation where one user has been given DBO Role Member ship on the master table. I want to revoke that. But When I revoke it, he is not able to add new users (to the instance) from his application (Navision). I want to revoke his dbo mapping on master, but give him some sort of role that he would be able to add users to the instance through the appliction. I have tried giving the securityadmin role and it isn't working for him.
sql serveruser rightsuser-group
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

What is the error message? Does the login get added to the instance but not the database?
0 Likes 0 ·
Depending on what version of Navision you would check Microsoft's documentation on what is minimally required.
0 Likes 0 ·

1 Answer

· Write an Answer
Grant Fritchey avatar image
Grant Fritchey answered
In order to give people security permissions on the server itself, to create logins, not just create users within a database, you must give them security_admin. But, read [the documentation][1] from Microsoft: > The securityadmin role should be > treated as equivalent to the sysadmin > role. I wouldn't recommend this approach unless you're planning on giving them the permission to create logins with 'sa' privileges. [1]: http://technet.microsoft.com/en-us/library/ms188659.aspx
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.