title: Access control permissions on Azure SQL database schema
body: <p>Please let me know if it is possible to restrict a user access to to a particular schema within a Azure SQL database. I know it is possible on an on-premise SQL database, however need to know if it is supported on Azure.</p>
  
  <p>Couldn’t find a concrete article where it states that security/access-control can be configured across Azure SQL database schemas.
  This is the most closer I could got on anything about schema access on Azure:</p>
  
  <p><a href="https://docs.microsoft.com/en-us/azure/sql-database/sql-database-manage-logins#permissions" rel="nofollow noreferrer">https://docs.microsoft.com/en-us/azure/sql-database/sql-database-manage-logins#permissions</a></p>
  
  <p>Also are there any restrictions on azure to query tables of a different schema on the same database. Specifically asking this as Azure doesn't support querying across databases just as it can be done on on-premise (though there is a workaround in elastic query).</p>