Meltano

<https://github.com/meltano/meltano/pull/10009|#10009 ci: Run dependency review check on `pull_request` triggers instead of `pull_request_target`>
Pull request opened by <https://github.com/edgarrmondragon|edgarrmondragon>
*Description*

The risks of `pull_request_target` are just not worth it.

*Checklist*

• I have read the <https://docs.meltano.com/contribute/merge/|contribution guide>

*Was generative AI tooling used to co-author this PR?*

• Yes (please specify the tool below)

*Related Issues*

• <https://github.com/meltano/meltano/pull/9682|#9682>
• <https://github.com/meltano/meltano/pull/9786|#9786>

*Summary by Sourcery*

Update dependency review workflow to run on pull_request events and simplify triggers.
CI:
• Run dependency review check on pull_request events instead of pull_request_target.
• Remove scheduled and manual workflow triggers and always run the dependency review action when the workflow is triggered.
<https://github.com/meltano/meltano|meltano/meltano>

<https://github.com/meltano/meltano/pull/10009|#10009 ci: Run dependency review check on `pull_request` triggers instead of `pull_request_target`>
Pull request merged by <https://github.com/edgarrmondragon|edgarrmondragon>
<https://github.com/meltano/meltano|meltano/meltano>