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

.Send mail to sqlcoffee.stretch737@simplelogin.com with questions or comments about this web site.