Microsoft Azure Elastic Pool Database - Create a limited user with select permission on one table

Published on Thursday, 3 October 2019

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'

More information here