Minimum permissions required to create tables and views.
What are the minimum permissions a login can have to create tables and views
on a database?
As a minimum you need to assign the user CREATE TABLE permission on the database
and ALTER permission on the schema where the table is going to be created. For
example:
USE YourDatabase
GO
GRANT ALTER ON Schema :: DBO TO UserLogin
GRANT CREATE TABLE TO UserLogin
GO
![[Company Logo Image]](images/SQLCofee.jpg)
