a)sel * from DBC.AccountInfo
where accountname = account..(this will give all accounts for database,users and profile)
if u want more details abt the account.....then
sel * from dbc.dbase
where accountname = account (this will give the default account for each database and the user)

b) sel account;