SQL Server 2008 – Create Temp table Permission/Access

Question:  Do we need any permission to create temp table in SQL Server?

Or

Question: Which permission is required to create temp table in SQL Server?

Answer:

No permissions are required to create temp tables.  Any user can create temp table, as long as they can connect to the SQL Server.


Example:

As user does not have permission to create a regular table

SQL Server 2008 – Create Temp table Permission

SQL Server 2008 – Create Temp table Permission

But user can create a temp table as

SQL Server 2008 – Create Temp table Permission

SQL Server 2008 – Create Temp table Permission

Temp Table as

SQL Server 2008 – Create Temp table Permission

SQL Server 2008 – Create Temp table Permission