Table creation in SQL Server 2005
Hi,
I need to prevent users to use CREATE TABLE but I need them to be able to execute a stored procedure that creates a table.
Is it possible to allow users to create tables in SQL Server 2005 only through a stored procedure?
Thanks in advance.
Software/Hardware used:
Software/Hardware used:
ASKED:
June 12, 2008 4:38 PM
UPDATED:
June 12, 2008 6:06 PM
RELATED QUESTIONS
- Stored procedures to script table data in SQL Server 2005
- how to create table using a subquery in sql server
- In SQL Server 2005, how do I display all permissions a user/login has? Is there a stored procedure to do this?
- Create a database in SQL Server 2005
- How to left or right justifying a text file
Answer Wiki:
Basically no. The CREATE TABLE privilege must be granted to the user in order a stored procedure they run to create a table dynamically. The exception is a temp table.
To see all answers submitted to the Answer Wiki: View Answer History.
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.