October 17, 2004 at 9:52 pm
Hello,
I have a user in a db pointing to an NT login A. I'd like to retain the permission for the user and point to a user to another login. I understand that I can use sp_change_user so is this possible?
Thanks
October 18, 2004 at 1:38 am
Permissions are assigned to the user so provided that you NT user has logon authority to your SQL box then you should be OK.
As a general point I would assign permissions to roles and then make users a member of that role.
It may seem a bit bureaucratic in small databases with only a few users but as usage increases it can save some major headaches.
October 18, 2004 at 7:13 am
I'd agree about using roles. This is exactly why you do it. Take a few minutes and move the permissions to a role and then ad your new user.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply