Re: User Mappings to TempDB

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 08/02/05

  • Next message: Anthony Spiteri: "Re: User Mappings to TempDB" 
    Date: Mon, 1 Aug 2005 22:01:55 -0500

    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.
>
>
  • Next message: Anthony Spiteri: "Re: User Mappings to TempDB"

    Relevant Pages

    • 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)
    • 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)
    • Re: The log file for database tempdb is full
      ... What would that query have to do with the tempdb ... which are automatically created in the tempdb database. ... Luckyly it is a test server so I have just ...
      (microsoft.public.sqlserver.server)
    • Re: database tempdb is full: Error: 9002, Severity: 17, State: 6
      ... Whatever size and growth increment you set will be the size it gets ... btw. Preferentially you should never see an actual tempdb data ... The log file for database 'tempdb' is full. ... recovery mode and has free space in both .mdf and .ldf files. ...
      (microsoft.public.sqlserver.server)