SELECT name AS username, create_date, modify_date, type_desc AS type, authentication_type_DESC AS authentication_type FROM sys.database_principals WHERE type NOT IN ('A', 'G', 'R', 'X') AND sid IS NOT null ORDER BY username;
And to remove a user one of the easiest ways both to see all the users and remove any of the individual users. After connecting to your Azure Database within the database in question identify the Security Branch and then the Users branch – right click on the user you wish to remove and select DELETE.
This follows on from the post whereby we were trying to creat a user see here
Creating Contained Users