55 Commits
Author SHA1 Message Date
Hai Cao b9277c3830 Add explicit CREATE TABLE permission check for table designer (#2128) 2023-07-06 16:19:50 -07:00
Hai Cao 2a30a648f7 Fix copying result header behavior #2125 (#2125) 2023-06-28 09:52:55 -07:00
Hai Cao 33b5cb98cd Use config instead of parameter for query editor result copy and fix some wording (#2124)
* Fix typo and update wording

* use config instead of parameter for copying result
2023-06-27 16:44:23 -07:00
Hai Cao dbcb156816 Add an option for copying with trailing line break in STS (#2122) 2023-06-27 10:18:57 -07:00
Hai Cao 165d89b00e remove Linked Server Login node from OE (#2097) 2023-06-14 11:19:59 -07:00
Hai Cao c21fde884f filter out db roles for user in sql db master (#2101) 2023-06-13 17:08:30 -07:00
Hai Cao 37469dcbbd Fix schema level search and refactor search code for user management (#2084) 2023-06-02 10:59:32 -07:00
Hai Cao eff103efba use singular form for securable display name (#2077) 2023-05-30 15:50:22 -07:00
Hai Cao c6e53ea753 use a config for table designer trigger behavior (#2070) 2023-05-18 10:09:24 -07:00
Hai Cao cb6dfeb68d Fix db role member (#2068) 2023-05-16 09:21:37 -07:00
Hai Cao 24a323b37d Fix effective permission column field (#2061)
* fix effective permission

* Revert "fix effective permission"

This reverts commit 5a97f108c640c7c2bfd22fe21852e880115ee7c9.

* remove column info for may
2023-05-12 14:38:16 -07:00
Hai Cao 0e7ed07a30 Fix schema handling in search result of User Management (#2057)
* fix schema filed in search result

* fix search for securable
2023-05-11 19:08:06 -07:00
Hai Cao f655c6d660 Fix a few securable search/permission issue related to Azure (#2056) 2023-05-11 13:15:08 -07:00
Hai Cao d525e88672 Add securable search and permission setting to User Management (#2052) 2023-05-10 18:20:06 -07:00
Hai Cao 8d48ff735b Remove extra connection in app role and db role (#2037) 2023-05-01 18:04:07 -07:00
Hai CaoandAlan Ren 35aa8d42de [User Management] Implement handlers for app role, db role and server role (#2030)
* contracts

* more contracts

* wire up

* add server role and rename data classes

* finish app role

* finish db role

* build

* finish server role

* register

* docs and dispose

* build

* fix issues

* fix null ref issue

* fix schema not being set issue

* fix password for app role

---------

Co-authored-by: Alan Ren <alanren@microsoft.com>
2023-04-28 07:56:15 -07:00
Hai Cao b5db164387 Port code for server role smo operations (#1996)
* port code for server role smo operations

* styling
2023-04-07 16:18:13 -07:00
Hai Cao 9b08993753 Port code for Application Role, Database Role, Permission Data and Securable search (#1992)
* port code for db role and app role

* port permissionData (wip)

* port securable search data
2023-04-06 10:17:46 -07:00
Hai Cao e8e8f3d892 fix default language for new login (#1978) 2023-03-31 13:00:36 -07:00
Hai Cao 17c9a99d24 Fix lock out for login update (#1923)
* Fix CanEditLockedOutState

* fix CanEditLockedOutState

* fix locked out
2023-03-08 18:17:23 -08:00
Hai Cao 19b7a180b5 Expose inner exceptions when sendError (#1919)
* send inner exception

* trim

* name

* format
2023-03-08 14:27:08 -08:00
Hai Cao 58477c35dc handle invalid uri (#1918) 2023-03-08 13:16:14 -08:00
Hai Cao 49f1b3a496 make default language handling robust (#1907) 2023-03-06 14:50:19 -08:00
Hai Cao cd53af992d [User Management] Fix server role drop for login (#1899) 2023-03-03 15:21:32 -08:00
Hai Cao e721a44588 [User Management] Fix a few bugs in login handlers (#1897) 2023-03-03 10:37:53 -08:00
Hai Cao bec0877e32 [User Management] Fix login handlers (#1896)
* fix default language

* fix update

* fix server role error with azure
2023-03-02 17:51:31 -08:00
Hai Cao b3ae394fa6 Login handlers: address comments and fix dispose (#1870) 2023-02-17 14:24:34 -08:00
Hai CaoandKarl Burtram 7ffc85d7fc Add login management handlers (#1868)
* update contracts

* finish creating/loading login for SQL Server

* support role read for azure and add more handlers

* fix advanced option flags

---------

Co-authored-by: Karl Burtram <karlb@microsoft.com>
2023-02-17 09:56:03 -08:00
Hai Cao bcf015f939 Fix datetimeoffset formatting (#1823) 2023-01-25 11:19:30 -08:00
Hai Cao f9597bacd8 bump DacFx (#1803) 2023-01-09 15:43:43 -08:00
Hai Cao ec071c8819 fix table designer with ledger table (#1788) 2022-12-15 10:28:29 -08:00
Hai Cao 1559b7c387 Make ParallelMessageProcessingTest stable by loose the assertion (#1786) 2022-12-13 15:01:01 -08:00
Hai Cao f86ebae9b8 Re-enable parallel message processing (#1741)
* add flag to handler

* cleanup

* concurrency control

* add flag for handler setters

* update service flags

* fix event handlers

* more handlers

* make sure behavior is unchanged if flag is off

* cleanup

* add test case for parallel processing

* comments

* stop dispatcher in test

* add log for request lifespan

* cleanup and add comments

* correctly release semaphore

* remove deleted file from merge

* use await for semaphore release

* move handler invocation to await and adjust test

* cleanup exception handling and wrapper

* space

* loose assertion condition to make test stable
2022-12-11 00:05:33 -08:00
Hai Cao 5b95880f71 bump DacFx (#1752) 2022-11-08 12:44:44 -08:00
Hai Cao 04c64223e2 [Table Designer] Only show index hash options when table is memory-optimized (#1714) 2022-09-28 10:26:59 -07:00
Hai Cao 11fef3a5db [Table Designer] Fix columnstore wording 2022-09-23 16:44:34 -07:00
Hai Cao 676819f669 Bump DacFx to support table rename in table designer (#1695) 2022-09-16 11:16:39 -07:00
Hai Cao 8c9c3359c3 add a PrimaryKey property to identify its tab (#1679) 2022-09-08 10:52:07 -07:00
Hai Cao bb38bcc5c8 bump DacFx to bring in table designer fixes (#1675) 2022-09-07 15:48:21 -07:00
Hai Cao 8f26a20950 [Table Designer] support hash index and column store index (#1672) 2022-09-06 13:32:43 -07:00
Hai Cao 23072250b7 [Table Designer] Add validators for computed col in PK and FK (#1653) 2022-08-25 16:30:47 -07:00
Hai Cao be649e6d65 Fix table designer reloading after only descriptions being updated (#1644) 2022-08-17 11:48:40 -07:00
Hai Cao fc955ad6cf DacFx vbump (#1632) 2022-08-12 16:14:38 -07:00
Hai Cao a9fe77589d [Table Designer] Support filter predicate and included columns for index (#1619) 2022-08-05 15:04:44 -07:00
Hai Cao fc2d1300fd A few table designer fixes (#1581)
* enable index rename

* use SystemName to fix constraint name validator
2022-07-21 16:25:35 -07:00
Hai Cao e190581094 Disable failing integration test (#1540) 2022-06-15 15:46:48 -07:00
Hai Cao 33636efa87 [Table Designer] Fix a few computed col issues (#1518) 2022-06-01 15:00:01 -07:00
Hai Cao bc1b60fa87 [Table Designer] Add apis to support computed column (#1495) 2022-05-23 15:41:07 -07:00
Hai Cao 262fd00afd fix memory optimized option inconsistent state (#1503)
* disable mem optimized instead of removing options

* bump DacFx
2022-05-23 13:27:18 -07:00
Hai Cao 24910c5b5c [Table Designer] api change for insert and move col (#1477)
* make api change for insert and move col
* bump DacFx
2022-05-06 15:00:34 -07:00
Hai Cao 35e1782a3f [Table Designer] Fix row start casing (#1467) 2022-04-15 15:37:26 -07:00
Hai Cao 52f71e8b79 [Table Designer] fix check for isPkDescEnabled (#1460) 2022-04-11 10:10:16 -07:00
Hai Cao 71830ee5f9 A few table designer improvements (#1456)
* add AdvancedType related contract & lib call

* use type list from col

* add description support to all view models

* remove desc for edge constraint

* bump DacFx to 160.6093.0-preview

* nit
2022-04-08 11:42:55 -07:00
Hai Cao 3b2ffe8aea change table designer report type to markdown (#1433) 2022-03-17 18:39:06 -07:00
Hai Cao adb82f2dd0 [Table designer] add a few column property edit handlers (#1339) 2021-12-14 15:56:06 -08:00