What kind of permission user required in SQL server 2016, to create/alert/delete File Group on database?
What kind of permission user required in SQL server 2016, to create/alert/delete File Group on database?
That are all ALTER DATABASE commands and requires at least ALTER DATABASE permissions, see ALTER DATABASE (Transact-SQL) => Permissions
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).
11 people are following this question.
Year and Month aggregation in same Pivot table in SQL Server
SQL Server Query for Searching by word in a string with word breakers
How to show first row group by part id and compliance type based on priorities of Document type?
Query to list all the databases that have a specific user
T-sql query to find the biggest table in a database with a clustered index