CODEWITHSUNDEEP
sql-serversql-grant
eNtsa2019 Mkontwana
eNtsa2019 Mkontwana

Reputation: 103

Fix "All permission is deprecated and maintained only for compatibility"

I am trying to run SQL Server query using this code below, each time query is executed I get the error.

The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

use eNtsaMemberRegistrationDB
go
grant all on TestUser to Users;

Upvotes: 0

Views: 5597

Answers (1)

Oren Meth
Oren Meth

Reputation: 53

According to the documentation "ALL" would imply granting the user all of the following permissions:

 - BACKUP DATABASE
 - BACKUP LOG
 - CREATE DATABASE
 - CREATE DEFAULT
 - CREATE FUNCTION
 - CREATE PROCEDURE
 - CREATE RULE
 - CREATE TABLE
 - CREATE VIEW

I would recommend identifying each permission the user requires and adding them individually to avoid including anything that you might not be aware/certain of and jeopardizing the security of your database.

Upvotes: 1

Related Questions