Re: Adding Permissions on TEMPDB every time computer restarts

From: Jason Tai (jastai@hotmail.com)
Date: 07/03/02 

From: "Jason Tai" <jastai@hotmail.com>
Date: Wed, 3 Jul 2002 08:36:50 -0700

Hi! Linda:

Thanks for the reply. But looks like only objects in
master database owned by the DBO can have the startup
option changed. Any thoughts? Thanks.

Jason
>-----Original Message-----
>Jason,
>
>> 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.
>
>You can put your grant statements in a stored procedure
>and then mark it for automatic execution at startup.
>
>exec sp_procoption 'yourprocedure', 'startup', 'true'
>
>
>Linda
>
>
>.
>