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

Vijay Kumar
1,996
Reputation points
What kind of permission user required in SQL server 2016, to create/alert/delete File Group on database?
Accepted answer
1 additional answer
Sort by: Most helpful
-
Cris Zhan-MSFT 6,566 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 OptionsExcept 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).