Re: Guest Account

From: Steve Thompson (SteveThompson@nomail.please)
Date: 04/07/03 

From: "Steve Thompson" <SteveThompson@nomail.please>
Date: Mon, 7 Apr 2003 11:33:46 -0400

"Leo" <nospam@nospam.com> wrote in message
news:040d01c2fd17$d0b6c7f0$a601280a@phx.gbl...
> I am trying to delete the guest account from the database:
> tempdb and master, in SQL server. However SQL server will
> not allow it. Is there a way to get rid of that account?
> What if I detach those two databases completely and get
> rid of them would there be any implications?
>
You cannot delete 'Guest', as you cannot delete 'Public'. Make sure you're
running Windows Authentication security mode, and you've disabled the Guest
account on your server. By default, 'guest' has no permissions Granted.

Steve

Relevant Pages

  • RE: Problems with WebParts
    ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: DTS Package fails when Scheduled
    ... Apparently I was unable to pass on the database password when runninig the ... Make sure SQL Server Agent account has the correct rights/permissions. ... scheduled job under this context, I still received the error, even though I ...
    (microsoft.public.sqlserver.dts)
  • Problems with WebParts
    ... The connection string specifies a local SQL Server Express instance using a ... database location within the applications App_Data directory. ... server account must have read and write access to the applications directory. ... logged-in user needs the dbcreator privilege in the appropriate SQL Server ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: public role???
    ... account existed for all these DBs. ... these users from viewing the master and tempdb DBs as well? ... then that's the way SQL Server ... >see if you have the "guest" account enabled in the other ...
    (microsoft.public.sqlserver.security)
  • Re: does sql user need to be an admin?
    ... User accounts need to be granted access to SQL Server in order to ... file permissions do not control database access. ... This account is a member of the ... Grant a Windows account access to SQL Server: ...
    (microsoft.public.sqlserver.security)