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.

more ▼

asked Oct 11, 2013 at 07:29 AM in Default

avatar image

230 8 10 15

What is the error message? Does the login get added to the instance but not the database?

Oct 11, 2013 at 11:43 AM KenJ

Depending on what version of Navision you would check Microsoft's documentation on what is minimally required.

Oct 11, 2013 at 02:45 PM Shawn_Melton
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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

more ▼

answered Oct 13, 2013 at 11:55 AM

avatar image

Grant Fritchey ♦♦
137k 20 47 81

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 11, 2013 at 07:29 AM

Seen: 660 times

Last Updated: Oct 14, 2013 at 03:12 PM

Copyright 2018 Redgate Software. Privacy Policy