Create User for Database
Name
create_user
Description
Create a new user which you can later use to create permission set and obtain resource token. [API reference]
Parameters
| Parameter | Label | Required | Options | Description |
|---|---|---|---|---|
| Database | Database Name (keep blank to use default) Case-Sensitive | NO | Leave blank to use default DB set on connection screen | |
| RequestBody | RequestBody | NO |
Output Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description |
|---|---|---|---|---|---|
| Id |
DT_WSTR
|
nvarchar(255)
|
255 | False |
The unique name that identifies the collection. |
| ResourceId |
DT_WSTR
|
nvarchar(2000)
|
2000 | False |
System generated property. The resource ID is a unique identifier that is also hierarchical per the resource stack on the resource model. It is used internally for placement and navigation of the permission resource. |
| LastUpdated |
DT_I4
|
int
|
False |
System generated property. Specifies the last updated timestamp of the resource. | |
| ETag |
DT_WSTR
|
nvarchar(4000)
|
4000 | False |
System generated property representing the resource etag required for optimistic concurrency control. |
| Permissions |
DT_WSTR
|
nvarchar(4000)
|
4000 | False |
System generated property that specifies the addressable path of the conflicts resource. During an operation on a resource within a collection, if a conflict occurs, users can inspect the conflicting resources by performing a GET on the conflicts URI path. |
If the column you are looking for is missing, consider customizing Cosmos DB Connector.
Input Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Examples
SSIS
Use Cosmos DB Connector in API Source component to read data or in API Destination component to read/write data:
Create User for Database using API Source
Cosmos DB
Create User for Database
Create User for Database using API Destination
Cosmos DB
Create User for Database
ODBC application
Use these SQL queries in your ODBC application data source:
Create user for database
SELECT * FROM create_userSQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
Create user for database
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM create_user';
EXEC (@MyQuery) AT [LS_TO_COSMOS_DB_IN_GATEWAY];