sys.fn_translate_permissions example

I couldn’t locate an output example of the function sys.fn_translate_permissions or how to really use it and hence this blog.
You’ll likely never have a need to use this function, but here goes…
The function has 2 arguments
level – which is nvarchar(60) and relevant entries can be found in sys.securable_classes
perms – which is varbinary(16) and integers up to 38 precision can be used e.g. 99999999999999999999999999999999999999 is ok, but adding another 9 would fail.
Below is the function in action:

Leave a Reply