|
Home > Archive > MS SQL Server > May 2005 > setting permissions on tempdb
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
setting permissions on tempdb
|
|
|
| Hi,
How can i set permissions back on the tempdb when sql server recreates the
tempdb. I use tempdb for storing temptables created by a dts package.
I need to set for 2 accounts the ddl, read/write on tempdb.
How do i do that?
| |
| Hari Prasad 2005-05-17, 11:23 am |
| Hi,
Try creating the user in Model database with adequate roles assigned. This
will create the user and assin the necessory roles to TEMPDB on each
sql server service restart.
Thanks
Hari
SQL Server MVP
"Jason" <jasonlewis@hotrmail.com> wrote in message
news:OPrwY8tWFHA.3584@TK2MSFTNGP14.phx.gbl...
> Hi,
>
> How can i set permissions back on the tempdb when sql server recreates the
> tempdb. I use tempdb for storing temptables created by a dts package.
>
> I need to set for 2 accounts the ddl, read/write on tempdb.
>
> How do i do that?
>
>
|
|
|
|
|