question

VijayKumar768 avatar image
0 Votes"
VijayKumar768 asked ·

File group and files create permission

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

sql-server-generalsql-server-transact-sql
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
1 Vote"
OlafHelper-2800 answered ·

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


·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Criszhan-msft avatar image
0 Votes"
Criszhan-msft answered ·

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


·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.