Reset Privacy Level of Actions Block on Profile

I want to run a MySQL command to set the privacy level for the actions block on all member's profile page to "members"   However, I am not quite sure which table holds the privacy setting for the actions block on the profile page.

By default, it's not viewable to public, if that's what you're worried about.

No, I need to reset the actions blocks so they are viewable to members.  I have some test users that have removed the actions block from view.  While I know that you can still use the pop-up to block and report spam on members, I think that block should always be in view.  Since I don't know which members have remove the block from view, I thought I would just set all blocks using a sql command.  I guess I could just hunt through the database and check since I don't have that many users and users in the future will not have the ability to remove the block.

The table is sys_page_compose_privacy

A entry has to be made for every member on your site.

The query would be this.

INSERT IGNORE INTO `sys_page_compose_privacy` (`user_id`,`block_id`,`allow_view_block_to`) SELECT `ID`,'65','4' FROM `Profiles`

You need to replace the 65 in the above query with the actual block id of your sites action block.

Thank you for the information.