Re: Adding Permissions on TEMPDB every time computer restarts

From: BP Margolin (bpmargo@attglobal.net)
Date: 07/03/02


From: "BP Margolin" <bpmargo@attglobal.net>
Date: Wed, 3 Jul 2002 14:20:56 -0400


Jason,

The tempdb is created anew each restart of SQL Server using the Model
database as its template. Can you just add the permissions to the Model
database?

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

"Jason Tai" <jastai@hotmail.com> wrote in message
news:14ca701c22289$a89c1360$9be62ecf@tkmsftngxa03...
> Hi! All:
>
> I need to find a way (possibly a script?) to add
> permissions for a user/group on TEMPDB everytime I reboot
> the server. It is because I have an ASP.NET application
> that needs the user to have access to the TEMPDB. It is
> a known issue that everytime you restart the SQL Server
> the permissions set on tempdb will disappear. Any
> suggestions? Thanks.
>
> Jason