It's the same info that you get to Administration > Users
The main table to search data, the one you can enable/disable users is ca_contact
select * from ca_contact
But if you have to access that data from outsite, you should use the webservice provided, that can get you the same data
Go to Administration > Tools > Webserices API (usm/API/SOAP/index.html) getUser method