Authorization in SQL Database
Authorization in Azure SQL Database determines which users and applications have access to your database and the permissions they have.
Azure SQL Database provides various methods for managing permissions, including:
- SQL Server Management Studio (SSMS): Use SSMS to manage permissions through a graphical interface.
- Azure Portal: Manage permissions through the Azure Portal.
- Azure PowerShell: Use Azure PowerShell cmdlets to manage permissions.
- Azure CLI: Use the Azure CLI to manage permissions.
Authentication Methods
Azure SQL Database supports multiple authentication methods:
- SQL Server Authentication: Users authenticate using a username and password.
- Azure Active Directory (Azure AD) Authentication: Users authenticate using their Azure AD credentials.
Role-Based Access Control (RBAC)
Use Azure RBAC to manage access to your SQL Database from other Azure resources.
You can assign roles to users or groups, granting them control over the database. Common roles include:
- db_owner: Full control over the database.
- db_datareader: Allows users to read data from the database.
- db_datawriter: Allows users to write data to the database.
- db_securityadmin: Allows users to manage security settings.