microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.56k stars 899 forks source link

Unable to assign database user to database role #22239

Closed erinstellato-ms closed 1 year ago

erinstellato-ms commented 1 year ago

Issue Type: Bug

  1. Within an Azure SQL Database, expand Security and then Users.
  2. Right-click on a user and select Properties.
  3. Within properties, select db_owner under Membership (not schema). Select OK.

The error is: Update user 'zzzzz' failed Error: The 'DefaultLanguage' property is not supported on Microsoft Azure SQL Database.

Azure Data Studio version: azuredatastudio-insiders 1.43.0-insider (b4d5a08199e9e0cb0138ce540c086ac32d072019, 2023-03-07T06:31:08.002Z) OS version: Windows_NT x64 10.0.22621 Restricted Mode: No Preview Features: Enabled

System Info |Item|Value| |---|---| |CPUs|11th Gen Intel(R) Core(TM) i7-1185G7 @ 3.00GHz (8 x 2995)| |GPU Status|2d_canvas: enabled
canvas_oop_rasterization: disabled_off
direct_rendering_display_compositor: disabled_off_ok
gpu_compositing: enabled
multiple_raster_threads: enabled_on
opengl: enabled_on
rasterization: enabled
raw_draw: disabled_off_ok
skia_renderer: enabled_on
video_decode: enabled
video_encode: enabled
vulkan: disabled_off
webgl: enabled
webgl2: enabled
webgpu: disabled_off| |Load (avg)|undefined| |Memory (System)|47.71GB (18.86GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|
Extensions (5) Extension|Author (truncated)|Version ---|---|--- import|Mic|1.5.4 kusto|Mic|0.5.8 query-history|Mic|0.5.3 schema-compare|Mic|1.18.0 sql-database-projects|Mic|0.22.0
erinstellato-ms commented 1 year ago

@alanrenmsft @kburtram

erinstellato-ms commented 1 year ago

Note: If I create a database user from the UX (after creating a login), and assign db_owner at creation, that does work.