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
But user can create a temp table as
Temp Table as