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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!