QuestionQ117
VerifiedImplement a secure environmentYou have an Azure subscription containing a group named Group1 and an Azure SQL Managed Instance hosting a database named DB1.
You must ensure that Group1 has read access to new tables created in DB1, using the principle of least privilege.
How should you complete the Transact-SQL statement?
Select
GRANT ON ::[table] TO [Contoso\group1]
Community Discussion