SQL Server: grant all 'public' users the permission to create tables I have a set of users who have the 'public' role.

According to the default settings, they can read, update, insert data inside existing tables.

How can I change the database settings to that they can as well create and ALTER tables of schema dbo?

If I click on "Alter role" for the database>decurity>Roles, there is a section 'extended properties" but I am not sure how to use this?

Thank you
Ensure you are in the correct database and then issue the following command:

GRANT CREATE TABLE TO public
GO


If you already have objects that require public to ALTER the table then you can add the following for each existing table:

GRANT ALTER ON OBJECT::dbo.your_table_name TO public
GO


Reference: GRANT (Transact-SQL)