January 5, 2010 at 12:43 pm
Hello,
I need to create the user with db reader and write priviledges.
As per the requirement , i am supposed map this new user with the existing LOGIN ( which has sysadmin privilidge) .
Can you please suggest if its a good decision to map this users with sysadmin login. Or what would be the access this user has i go with this mapping.
Thanks
January 5, 2010 at 12:52 pm
A user with sysadmin server rights has full access to everything in the instance.
January 5, 2010 at 12:57 pm
Thanks for replying.
If i understand correctly , you mean when user will get mapped to login then that user wil lbe able to perform any admin activity on the server.
January 5, 2010 at 1:02 pm
Actually, the users login doesn't even need to be mapped to a user in a database to have access sice it has sysadmin rights at the server level.
January 5, 2010 at 1:09 pm
Ok. Can you please suggest me which starategy i should follow :
a) create the login with default access
b) create the user with desired access and map the same with above mentioned login.
My requirement is to create the user with dbreader , writer and execute privilidges. And there is one login with already the same name exisiting in the server with sysadmin priviledge. In this case should i map my new user with some other login ?
January 5, 2010 at 1:14 pm
Basically, you got the idea.
The user will need a different login if you want to restrict access, but still provide the user with the other login that basically has god-like rights to instance.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply