Grant admins access to view all current Private Reports - Stored Procedure

Sometimes a Yellowfin administrator may wish to be able to see all private reports in the system. 

Attached is a script to create a stored procedure that will add the administrator's account to all existing private reports so that he/she will be able to access them. (It is for SQL Server, but if you are using a different database you can still get an idea of how to write a procedure from it)

Once you have run the script and thus created the stored procedure, to execute it all you have to do is run the following in SQL Management Studio:

exec sp_Add_PersonId_to_private_report <insert your PersonId here>

and it will give you access to all private reports in the system.

Is article helpful?