Adding Permissions on TEMPDB every time computer restarts
From: Richard Siddaway (rsiddaw@hotmail.com)
Date: 07/03/02
- Next message: MegaMax: "Re: How change SQL Server Authentication mode without EnterpriseManager?"
- Previous message: Sue Hoegemeier: "Re: Adding Permissions on TEMPDB every time computer restarts"
- In reply to: Jason Tai: "Adding Permissions on TEMPDB every time computer restarts"
- Next in thread: BP Margolin: "Re: Adding Permissions on TEMPDB every time computer restarts"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Richard Siddaway" <rsiddaw@hotmail.com> Date: Wed, 3 Jul 2002 07:22:17 -0700
look in books on line under startup - there's a way to
have a routine run at server startup. Alternatively
you could put the permissions into the model database
which is used to creat etempdb BUT every other database
you create on that server will get those permissions
>-----Original Message-----
>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
>.
>
- Next message: MegaMax: "Re: How change SQL Server Authentication mode without EnterpriseManager?"
- Previous message: Sue Hoegemeier: "Re: Adding Permissions on TEMPDB every time computer restarts"
- In reply to: Jason Tai: "Adding Permissions on TEMPDB every time computer restarts"
- Next in thread: BP Margolin: "Re: Adding Permissions on TEMPDB every time computer restarts"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
