Re: user permissions

Hi Ola,
Thanks for your response.

My appologies for not carefully testing this, yes, you are right.
IMPERSONATE permission must be granted on the login account with sysadmin
and processadmin to the limited login account.

Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================

.

Relevant Pages

  • Re: user permissions
    ... Erland Sommarskog has an article on his web site about this. ... IMPERSONATE permission must be granted on the login account with sysadmin ... Microsoft Online Community Support ... Please feel free to let my manager ...
    (microsoft.public.sqlserver.security)
  • Re: Network Manager without a password
    ... Manager asks me the password every time to activate the wireless... ... I recall this might have something to do with the fact that you may ... login account. ... I use NM and it never prompts me to connect to my WAP, ...
    (Ubuntu)
  • Re: Network Manager without a password
    ... Manager asks me the password every time to activate the wireless... ... I recall this might have something to do with the fact that you may ... login account. ... I use NM and it never prompts me to connect to my WAP, ...
    (Ubuntu)
  • Re: user permissions
    ... to kill a connection on your database with a limited login account, ... Use EXECUTE AS clause to impersonate a login account who has enough ... Grant EXECUTE permission to the user account who is corresponding to ...
    (microsoft.public.sqlserver.security)