swaping logins

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

  • 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 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply