Where in the repository can you give additional users access to secret scanning alerts?

To grant specific users access to view and manage secret scanning alerts, you do this via the Settings tab of the repository. From there, under the "Code security and analysis" section, you can add individuals or teams with roles such as security manager.

The Security tab only displays alerts; access control is handled in Settings.