Here are the list of people responsible for a self-destruct sequence in Star Trek:
* Captain KIrk, Commander Spock, Lt. Commander Scott - Let That Be Your Last Battlefield
* Admiral Kirk, Commander Scott, Commander Chekov - The Search for Spock
* Captain Picard, Commander Riker - 11001001 & Where Silence Has Lease
* Captain Sisko, Major Kira - The Adversary
* Captain Janeway - Deadlock & Dreadnought
* Captain Picard, Commander Crusher, Lt. Commander Worf - First Contact
* Captain Picard - Nemesis
One thing to note about this: 10 of the 11 people here have a high Starfleet rank (at least Lt. Commander - with Major Kira of the Bajoran Militia the sole exception). Is it possible that the auto-destruct sequence must be accessed by someone granted at least Lieutenant Commander rank by Starfleet Command? On Voyager, Tuvok started out as a Lieutenant (negating production inconsistencies), and Chakotay was only ever granted a provisional rank. Both were promoted at Janeway's discretion, with no outside agency possible (until the last seasons). Kira (as the equivalent of a Lt. Commander) would have been granted this authority over perhaps only the Defiant by Starfleet.
Worf in First Contact, and perhaps all of them in The Search for Spock (they're mutineers, and assigned to the Academy, the Excelsior, and the Reliant, respectively), still held authorization from Starfleet to destruct a ship that they do not belong to, leading credence that Starfleet authorizes all (command-level?) Lieutenant Commanders authority to at least concur in a self-destruct sequence in an emergency. The Captain (or Admiral in one case) has always been the necessary initiator, with only Janeway's (and Picard's "Omega" sequence in Nemesis) being the only instance of no concurrence necessary or perhaps possible. And, with the exception of Admiral Kirk in TSFS (Admiral's discretion? carry-over from his authorization in The Wrath of Khan?), all Captains were the permanent, assigned CO of that Starfleet.
* Captain KIrk, Commander Spock, Lt. Commander Scott - Let That Be Your Last Battlefield
* Admiral Kirk, Commander Scott, Commander Chekov - The Search for Spock
* Captain Picard, Commander Riker - 11001001 & Where Silence Has Lease
* Captain Sisko, Major Kira - The Adversary
* Captain Janeway - Deadlock & Dreadnought
* Captain Picard, Commander Crusher, Lt. Commander Worf - First Contact
* Captain Picard - Nemesis
One thing to note about this: 10 of the 11 people here have a high Starfleet rank (at least Lt. Commander - with Major Kira of the Bajoran Militia the sole exception). Is it possible that the auto-destruct sequence must be accessed by someone granted at least Lieutenant Commander rank by Starfleet Command? On Voyager, Tuvok started out as a Lieutenant (negating production inconsistencies), and Chakotay was only ever granted a provisional rank. Both were promoted at Janeway's discretion, with no outside agency possible (until the last seasons). Kira (as the equivalent of a Lt. Commander) would have been granted this authority over perhaps only the Defiant by Starfleet.
Worf in First Contact, and perhaps all of them in The Search for Spock (they're mutineers, and assigned to the Academy, the Excelsior, and the Reliant, respectively), still held authorization from Starfleet to destruct a ship that they do not belong to, leading credence that Starfleet authorizes all (command-level?) Lieutenant Commanders authority to at least concur in a self-destruct sequence in an emergency. The Captain (or Admiral in one case) has always been the necessary initiator, with only Janeway's (and Picard's "Omega" sequence in Nemesis) being the only instance of no concurrence necessary or perhaps possible. And, with the exception of Admiral Kirk in TSFS (Admiral's discretion? carry-over from his authorization in The Wrath of Khan?), all Captains were the permanent, assigned CO of that Starfleet.