Re: How to Grant a user to view SQL Server Log

From: david (nospam-noreply@nospam.com)
Date: 09/30/02


From: "david" <nospam-noreply@nospam.com>
Date: Mon, 30 Sep 2002 13:18:16 +1000


thanks for replying. I wonder if it is possible to let the user view the
errorlog using Enterprise Manager ?

"Umachandar Jayachandran" <please_reply_to_newsgroup_only> wrote in message
news:ucPdt50ZCHA.1696@tkmsftngp09...
> You can add the login to master db & give the user execute permission
on
> xp_readerrorlog.
>
> --
> Umachandar Jayachandran
> SQL Resources at http://www.umachandar.com/resources.htm
> ( Please reply only to newsgroup. )
>
>



Relevant Pages

  • Locked out of Enterprise Manager
    ... I went into the Server Config properties and changed to Windows ... My login for Start and Run SQL server was in this format. ... Enterprise Manager lost connection and would no longer connect.. ...
    (microsoft.public.sqlserver.security)
  • Re: Storing/saving sessions on SQL Server
    ... If you dont have enterprise manager, download SQL ... "SQL Server does not exist or access denied. ... "Cannot open database requested in login 'ASPState'. ...
    (microsoft.public.dotnet.framework)
  • Re: Change in sa password, scheduled jobs failing
    ... The sa login and password are likely referenced in the ... login and you right click on the package, select Schedule ... this will create an encrypted DTSRun command in the ... currently be logged in as through Enterprise Manager. ...
    (microsoft.public.sqlserver.dts)
  • Re: Change in sa password, scheduled jobs failing
    ... The sa login and password are likely referenced in the ... login and you right click on the package, select Schedule ... this will create an encrypted DTSRun command in the ... currently be logged in as through Enterprise Manager. ...
    (microsoft.public.sqlserver.server)
  • Re: Change in sa password, scheduled jobs failing
    ... The sa login and password are likely referenced in the ... login and you right click on the package, select Schedule ... this will create an encrypted DTSRun command in the ... currently be logged in as through Enterprise Manager. ...
    (microsoft.public.sqlserver.programming)