Permissions to create & drop tables?

Hello what are the minimum permissions to allow a user to view, create, & drop tables within a DB (SQL 2008)?

Thanks in advance.

July 31st, 2015 1:20pm

I guess the user should be part of these DB roles:

 db_alterdefinition,

 db_datareader,

db_datawriter,

db_Execute,

db_Viewdefinition

Free Windows Admin Tool Kit Click here and download it now
July 31st, 2015 1:40pm

You need to be db_DDLADMIN and  db_accessadmin for creating tables and since 2008 you might need permission to alter schema and accessadmin should do that.

https://msdn.microsoft.com/en-us/library/ms173790.aspx?f=255&MSPPError=-2147217396

July 31st, 2015 3:14pm

the minimum?

Create Table on Database and Alter Schema on the respective schema/schemas

GRANT CREATE TABLE TO SomeuserRole
GO
GRANT ALTER SCHEMA
    ON SCHEMA::dbo
    TO SomeuserRole
GO

Free Windows Admin Tool Kit Click here and download it now
July 31st, 2015 4:19pm

Thanks everyone.
July 31st, 2015 5:09pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics