File group and files create permission

Question

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

Answer 1

That are all ALTER DATABASE commands and requires at least ALTER DATABASE permissions, see ALTER DATABASE (Transact-SQL) => Permissions

Answer 2

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).