demo

  
entity_name
subentity_name
permission_name

1
database

CREATE TABLE

2
database

CREATE VIEW

3
database

CREATE PROCEDURE

4
database

CREATE FUNCTION

5
database

CREATE RULE

6
database

CREATE DEFAULT

7
database

BACKUP DATABASE

8
database

BACKUP LOG

9
database

CREATE TYPE

10
database

CREATE ASSEMBLY

11
database

CREATE XML SCHEMA COLLECTION

12
database

CREATE SCHEMA

13
database

CREATE SYNONYM

14
database

CREATE AGGREGATE

15
database

CREATE ROLE

16
database

CREATE MESSAGE TYPE

17
database

CREATE SERVICE

18
database

CREATE CONTRACT

19
database

CREATE REMOTE SERVICE BINDING

20
database

CREATE ROUTE

21
database

CREATE QUEUE

22
database

CREATE SYMMETRIC KEY

23
database

CREATE ASYMMETRIC KEY

24
database

CREATE FULLTEXT CATALOG

25
database

CREATE CERTIFICATE

26
database

CREATE DATABASE DDL EVENT NOTIFICATION

27
database

CONNECT

28
database

CONNECT REPLICATION

29
database

CHECKPOINT

30
database

SUBSCRIBE QUERY NOTIFICATIONS

31
database

AUTHENTICATE

32
database

SHOWPLAN

33
database

ALTER ANY USER

34
database

ALTER ANY ROLE

35
database

ALTER ANY APPLICATION ROLE

36
database

ALTER ANY SCHEMA

37
database

ALTER ANY ASSEMBLY

38
database

ALTER ANY DATASPACE

39
database

ALTER ANY MESSAGE TYPE

40
database

ALTER ANY CONTRACT

41
database

ALTER ANY SERVICE

42
database

ALTER ANY REMOTE SERVICE BINDING

43
database

ALTER ANY ROUTE

44
database

ALTER ANY FULLTEXT CATALOG

45
database

ALTER ANY SYMMETRIC KEY

46
database

ALTER ANY ASYMMETRIC KEY

47
database

ALTER ANY CERTIFICATE

48
database

SELECT

49
database

INSERT

50
database

UPDATE

51
database

DELETE

52
database

REFERENCES

53
database

EXECUTE

54
database

ALTER ANY DATABASE DDL TRIGGER

55
database

ALTER ANY DATABASE EVENT NOTIFICATION

56
database

ALTER ANY DATABASE AUDIT

57
database

ALTER ANY DATABASE EVENT SESSION

58
database

KILL DATABASE CONNECTION

59
database

VIEW DATABASE STATE

60
database

VIEW DEFINITION

61
database

TAKE OWNERSHIP

62
database

ALTER

63
database

CONTROL


  
i
b

1
10
z