File group and files create permission

Vijay Kumar 2,036 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?

Developer technologies | Transact-SQL
SQL Server | Other
0 comments No comments
{count} votes

Accepted answer
  1. Olaf Helper 47,441 Reputation points
    2021-02-26T07:02:41.877+00:00

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

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Cris Zhan-MSFT 6,661 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 No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.