What kind of permission user required in SQL server 2016, to create/alert/delete File Group on database?
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).
11 people are following this question.