Priveleges needed for

Question

I want to create a user with these privileges to create\delete table, insert\delete records in the tables. What type of permission do I need to provide them?

Amira Bedhiafi · Answer

I already answered a similar question years ago on SOF : database - What privileges are needed to create\delete tables on a Microsoft SQL Server? Is dbowner ok? - Stack Overflow Just to understand first the benefits of using roles : Roles are a part of the tiered security model: Login security—Connecting to the server Database security—Getting access to the database Database objects—Getting access to individual database objects and data** Predefined database roles You may need to create your own, but you have access to several predefined database roles: db_owner: Members have full access. db_accessadmin: Members can manage Windows groups and SQL Server logins. db_datareader: Members can read all data. db_datawriter: Members can add, delete, or modify data in the tables. db_ddladmin: allows a user to create, drop, or modify any objects within a database, regardless of who owns. db_securityadmin: Members can modify role membership and manage permissions. db_bckupoperator: Members can back up the database. db_denydatareader: Members can’t view data within the database. db_denydatawriter: Members can’t change or delete data in tables or views. Fixed roles : The fixed server roles are applied serverwide, and there are several predefined server roles: SysAdmin: Any member can perform any action on the server. ServerAdmin: Any member can set configuration options on the server. SetupAdmin: Any member can manage linked servers and SQL Server startup options and tasks. Security Admin: Any member can manage server security. ProcessAdmin: Any member can kill processes running on SQL Server. DbCreator: Any member can create, alter, drop, and restore databases. DiskAdmin: Any member can manage SQL Server disk files. BulkAdmin: Any member can run the bulk insert command.

Priveleges needed for

Answers (1)