Re: user permissions

Another option is to mark a database (e.g. master) as trustworthy and create
a stored procedure WITH EXECUTE AS OWNER.

Erland Sommarskog has an article on his web site about this.
http://www.sommarskog.se/grantperm.html

Ola Hallengren
http://ola.hallengren.com



"Charles Wang[MSFT]" wrote:

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
    ... IMPERSONATE permission must be granted on the login account with sysadmin ... and processadmin to the limited login account. ... Microsoft Online Community Support ... Please feel free to let my manager ...
    (microsoft.public.sqlserver.security)
  • Re: SysLink Control Problem
    ... I reproduce this issue on my machine, and I can see in the Process Explorer that the two versions of the ComCtl32 loaded by Word. ... Microsoft Online Community Support ... You can send feedback directly to my manager at: ... reproduce the problem in an Outlook COM addin based on KB 230689. ...
    (microsoft.public.win32.programmer.ui)
  • Re: SysLink Control Problem
    ... Microsoft Online Community Support ... You can send feedback directly to my manager at: ... reproduce the problem in an Outlook COM addin based on KB 230689. ... it is the Exchange client extension ...
    (microsoft.public.win32.programmer.ui)
  • Re: VS2008 not working in XP 64
    ... to isolate user profile corruption related causes. ... Microsoft Online Community Support ... You can send feedback directly to my manager at: ...
    (microsoft.public.vsnet.ide)
  • RE: Threaded Word File Conversion
    ... Hello Chuck, honestly, I am a little surprised to see it takes seconds per ... DateTime start = DateTime.Now; ... Microsoft Online Community Support ... You can send feedback directly to my manager at: ...
    (microsoft.public.office.developer.automation)