Recently I needed to create a very retricted user within Azure SQL using an Elastic Pool database to only access one table.
CREATE USER [LimitedUser] WITH PASSWORD = 'strongPassword';
CREATE ROLE [LimitedRole]
GRANT SELECT ON [TABLE] to [LimitedRole]
EXEC sp_addrolemember 'LimitedRole', 'LimitedUser'