Using fn_builtin_permissions

You can make use of the built-in sys.fn_builtin_permissions SQL function to get a list of available permissions, as shown below:

SELECT * FROM sys.fn_builtin_permissions(DEFAULT);SELECT * FROM sys.fn_builtin_permissions('');