File group and files create permission

Vijay Kumar 2,016 Reputation points
2021-02-26T01:11:26.37+00:00

What kind of permission user required in SQL server 2016, to create/alert/delete File Group on database?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,641 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,547 questions
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Cris Zhan-MSFT 6,601 Reputation points
    2021-03-04T02:27:16.65+00:00

    Hi,

    As Olaf said, users need to call the ALTER DATABASE [..] command to Add/Remove/Modify the database files/filegroups, and at least ALTER permission on the database is required.
    ALTER DATABASE (Transact-SQL) File and Filegroup Options

    Except for members of certain fixed server roles (sysadmin, dbcreator) or database roles (db_owner) that have this permission, you need to manually grant the user this permission (GRANT ALTER ON DATABASE:: test TO user).

    0 comments