在Azure SQL数据库中使用应用程序角色 [英] Using Application Roles in Azure SQL Database

问题描述

你好

我想在我的Azure SQL数据库中使用应用程序角色.我在彼此冲突的Microsoft网站上找到了两篇有关Azure SQL数据库中的应用程序角色的文章.有人告知应用程序角色在Azure SQL中受支持 数据库，其他提示不正确.

i would like to use Application Roles in my Azure SQL Database. I found two articles about Application Roles in Azure SQL Database on Microsoft sites that conflicting with each other. One informs that  Application Roles  is supported in Azure SQL Database, other informs that is not true.

下面的链接:

https://docs.microsoft.com/zh-cn/sql/relational-databases/security/authentication-access/application-roles?view=sql-server-2017#related-tasks

https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/application-roles?view=sql-server-2017#related-tasks

https://docs.microsoft.com/zh-cn/sql/relational-databases/system-stored-procedures/sp-setapprole-transact-sql?view=sql-server-2017&viewFallbackFrom=sql-server -2014

https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-setapprole-transact-sql?view=sql-server-2017&viewFallbackFrom=sql-server-2014

1.有人可以向我解释Azure SQL数据库支持应用程序角色吗?

1. Can somebody explain me that Application Roles is supported in Azure SQL Database?

2.如果上面的第一点是正确的，将来在Azure SQL数据库中会支持吗?

2. If first point above is correct, will it be supported in the future in Azure SQL Database?

关于

雅各布

推荐答案

Hello,

However, you can use Azure Active Directory for creating application roles as stated on below document.

https://techcommunity.microsoft.com/t5/Azure-Active-Directory-Identity/Azure-Active-Directory-now -with-Group-Claims-and-Application/ba-p/243862

https://techcommunity.microsoft.com/t5/Azure-Active-Directory-Identity/Azure-Active-Directory-now-with-Group-Claims-and-Application/ba-p/243862

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

这篇关于在Azure SQL数据库中使用应用程序角色的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！