Re: User Mappings to TempDB

From: Anthony Spiteri (AnthonySpiteri_at_discussions.microsoft.com)
Date: 08/02/05 

Date: Mon, 1 Aug 2005 20:23:02 -0700

Hmm, that would present just as much work in removing the user for every new
database that we create...

I am thinking that a script at startup would be the best option...but any
alternatives to that would be great.

"Dan Guzman" wrote:

> You can add the user to the model database so that all newly created
> databases, including tempdb, contain the user. If you don't want the user
> in a new database, you'll need to drop the user after database creation.
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVP
>
> "Anthony Spiteri" <Anthony Spiteri@discussions.microsoft.com> wrote in
> message news:1D912905-19F0-4695-8D42-DF8C3972AA60@microsoft.com...
> > Been having a look online to get a solution to the following.
> >
> > Just want to have a sql account always mapped to the the TempDb with
> > specific rights.
> >
> > At the moment, every restart/cluster move removes the user mappings I had
> > set.
> >
> >
>
>
>

Relevant Pages

  • Re: Database recovery with data file only
    ... Basically using that command breaks your business logic as there's no ... "Dan Guzman" wrote in message ... >> database Backup as well as ... >>> SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Thank you very much...again
    ... For information about the Microsoft Strategic Technology ... Protection Program and to order your FREE Security Tool Kit, ... | delete..etc permissions on tempdb. ... |>database which would avoid some of this. ...
    (microsoft.public.sqlserver.security)
  • Re: Can I move tempdb?
    ... Tempdb file name changes take affect after SQL Server is restarted and are ... reference posted by details procedures for moving other database files. ... Model isn't used to determine database file locations. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL server 6.5 unable to start
    ... put tempdb in RAM (start in minimum mode, ... default database device. ...
    (microsoft.public.sqlserver.server)
  • How many logical volumes for large database?
    ... We are about to migrate a large database server onto new ... Logs, and TempDB. ... First, we had four available SCSI channels, so by creating four arrays each ... course TempDB grows and shrinks as needed. ...
    (microsoft.public.sqlserver.server)