locked
A question about restricting access to resources using Roles. RRS feed

  • Question

  • A question about restricting access to resources using Roles.

    Is it possible to set the following access restrictions?

    * Set access restrictions for Data Lake Storage in directory units

    * Setting access restrictions for Comos DB on a container basis


    • Edited by pocket8137 Wednesday, February 19, 2020 2:06 PM
    Monday, February 17, 2020 2:51 PM

All replies

  • For Data Lake Storage, by "Directory Units", I assume you are referring to "Analytics Units". you can use Data Lake Analytics Developer role.

    For CosmosDB, the built in Azure RBAC roles allow you to set restrictions at an account level, you cannot define at a container level.

    By "Table unit setting for SQL Server", do you mean Pricing model? i.e DTU/vCore and the ability to adjust scaling?

    If yes, you can use SQL DB Contributor role for a single database or SQL Server Contributor role for the entire server.

    The above roles for Azure SQL let you manage the database/server but do not allow access to data.

    Tuesday, February 18, 2020 6:13 AM
  • Thank you for answering.

    Wednesday, February 19, 2020 2:05 PM