EC-Council
312-92 · Question #35
Darren has just been hired on as the SQL dba for Fredrickson Inc., a marketing firm in New York City. He has been asked to clearn up the SQL databases on one of the servers. What SQL stored…
The correct answer is A. sp_revokedbaccess. See the full explanation below for the reasoning.
Question
Darren has just been hired on as the SQL dba for Fredrickson Inc., a marketing firm in New York City. He has been asked to clearn up the SQL databases on one of the servers. What SQL stored procedure could Darren use to remove user accounts from the databases?
Options
- Asp_revokedbaccess
- Bsp_revokeusers
- Csp_removeoldusers
- Dsp_denyaccess
How the community answered
(65 responses)- A71% (46)
- B3% (2)
- C18% (12)
- D8% (5)
Community Discussion
No community discussion yet for this question.