Posted by Erland Sommarskog on 08/22/07 21:36

monty (manishgandhi13@gmail.com) writes:
> I am creating and using a temp table. For doing this db_ddladmin role
> will be enough??

I'm sorry, but I would appreciate if you could post your actual code
or in other ways to give me sufficient information what you are doing.
If you insist on just providing pieces, the quality of the answers you
get will be poor.

To create temp tables you need no particular permissions at all.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: ssis EXEC command
• Prev in forum: Re: SQL sever 2005 express move windowns authentication choice to mixed authentication
• Thread view: Re: Problem with DB_OWNER role..

[Reply to this message]