Hello what are the minimum permissions to allow a user to view, create, & drop tables within a DB (SQL 2008)?
Thanks in advance.
Technology Tips and News
Hello what are the minimum permissions to allow a user to view, create, & drop tables within a DB (SQL 2008)?
Thanks in advance.
I guess the user should be part of these DB roles:
db_alterdefinition,
db_datareader,
db_datawriter,
db_Execute,
db_Viewdefinition
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
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