These set parameters display information about predicated privileges:
set show_transformed_sql command displays the full SQL query, including the added predicates for row-level filtering. When used with set noexec on, you can validate the final SQL query after the relevant predicates for the user, group, and active roles have been added, without executing the query.
set show_permission_source display the grantee, type of grantee, grantor, action, object and predicate in tabular form.
See the Reference Manual: Commands.
These system procedures display information about predicated privileges:
sp_helptext displays the predicate text. Include the predicate’s user-defined name, if there is one, or its internal name with sp_helptext:
sp_helptext pred1 # Lines of Text --------------- 1 text ------------------------------------------------------ grant select on tab1 where col1 = 5 as pred1 to robert
sp_helptext only displays results not previously hidden by sp_hidetext.
This example displays the predicate with the source text hidden by sp_hidetext:
Msg 18406, Level 16, State 1: Procedure 'sp_helptext', Line 313: Source text for compiled object pred1 (id = 592002109) is hidden.
sp_helprotect lists the name of the predicated privilege, if any, in the predicate column.
See the Reference Manual: Procedures.
