Yhyjyk

While re-watching DS9 "The Adversary" (S3E26), in the scene where Miles O'Brien almost catches a hostile changeling infiltrating the Defiant, it occurred to me that I didn't know if Miles even had the authority to initiate an intruder alert. Traditionally, we see captains giving the order for a ship to go to alert status, but in this case, O'Brien is only an enlisted crewman.

Now, obviously the computer shouldn't allow just anyone to register an alert, and I suspect this is why most non-Captains report to the Captain and allow them to make the call. However, one could also imagine a situation where an ordinary crewman (like O'Brien) came across a time sensitive issue, and needed to trigger an alert immediately.

So, my question is this: Who actually has the authority to trigger the different alert levels on a ship (Red, Yellow, and Intruder)? And could O'Brien have triggered a security alert from engineering without the Captain's authorization?

Red and Yellow (and Black and Grey and Blue) alerts

The TNG Technical Manual indicates that the command authority to signal alert conditions (or give any shipwide orders) ultimately rests with the vessel's Commanding Officer, typically a captain, and, by extension, their First and Second Officers. Additionally, Red and Yellow alerts can also be triggered by event conditions (such as the failure of a critical system or someone pointing lasers at you) although these can be overriden by the commander if there's a good reason to do so.

Within the bridge itself, it's the Operations (Ops) Manager who is responsible for physically setting the ship to condition red or yellow but the computer can also be ordered to do this by one of the ship's command staff and can also do this automatically. The next order is usually to inform the Captain (or most senior officer) that their presence is required on the bridge.

Operational authority for the starship rests with the Commanding
Officer (usually the captain or duty officer). The Commanding Officer
is responsible for execution of Starfleet orders and policy, as well
as for interpretation and compliance with Federation law and
diplomatic directives. As such, the Commanding Officer is directly
answerable to Starfleet Command for the performance of the ship.

The Main Bridge is directly responsible for the supervision of all
primary mission functions. Through the Operations Manager, the bridge
also monitors all secondary mission functions to provide an optimal
operating state. The multimission operational profile of the
Enterprise requires extensive coordination between different
departments.

Intruder alerts.

By comparison, the command ....

"Intruder Alert!"

... can be given by any member of the crew and can be done verbally or via a comm panel. The ship may also declare an intrusion alert on its own without a crewman being present.

This alert signals to the bridge Chief of Security that an intruder has been spotted which will, presumably, result in the arrival of a security team as well as informing the bridge that an intruder is suspected.