Classification of SQL Server permissions

SQL Server permissions can be divided into three categories

On the first type of server level:

SELECT * from sys.fn_builtin_permissions (default)

Where Class_desc like ' server ';

　　　　

The second type of database plane:

SELECT * from sys.fn_builtin_permissions (default)
Where Class_desc like ' database ';
　　　　

The third type of schema level:

SELECT * from sys.fn_builtin_permissions (default)
Where Class_desc like ' schema ';
　　　　

--------------------------------------------------------------------------------------------------------------- ----------------------------

Authorized:

　　　　Grant permission to Grantee_principal [with GRANT option] [as Grantor_principal];

Refused:

　　　　Deny permission to Grantee_principal [Cascade] [as Grantor_principal];

Classification of SQL Server permissions