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'
Tags
c# (3)
Statiq (3)
General (2)
javascript (1)
Azure (1)
Penny Pinching (1)
asp.net (1)
MSSQL (1)
Windows (1)
jQuery (1)
Share this
TweetConnect with me
Tweets by TryingToCode