ssas.model_json_35_roles - V :: DataHandwerk Docs

Description

Examples

Entity Diagram

Columns

Table 1. Columns of ssas.model_json_35_roles - V
PK	Column Name	Data Type	NULL?
1	databasename	`nvarchar(128)`	`NOT NULL`
2	roles_name	`nvarchar(500)`	`NULL`
	roles_members_ja	`nvarchar(max)`	`NULL`
	roles_modelPermission	`nvarchar(500)`	`NULL`
	roles_tablePermissions_ja	`nvarchar(max)`	`NULL`

Foreign Key Diagram

References

Referenced Objects

ssas.model_json_20 - V

Referencing Objects

Object Reference Diagram - 1 1

Object Reference Diagram - Referenced - 30 0

Object Reference Diagram - Referencing - 0 30

Column Reference Diagram

Indexes

PK_model_json_35_roles

IndexSemanticGroup: no_group
- databasename; nvarchar(128)
- [column-roles_name]; nvarchar(500)
PK, Unique, Real: 1, 1, 0

idx_model_json_35_roles__2

IndexSemanticGroup: no_group
- databasename; nvarchar(128)
PK, Unique, Real: 0, 0, 0

Column Details

_

databasename

1

databasename

nvarchar(128)

NOT NULL

Referenced Columns

ssas.model_json_20.databasename

Referencing Columns

roles_name

2

roles_name

nvarchar(500)

NULL

Referencing Columns

roles_members_ja

nvarchar(max)

NULL

roles_modelPermission

nvarchar(500)

NULL

roles_tablePermissions_ja

nvarchar(max)

NULL

sql_modules_definition

ssas.model_json_35_roles - V script

/*
--check

Select
    Distinct
    j2.[Key]
  , j2.Type
From
    ssas.model_json_20                      As T1
    Cross Apply OpenJson ( T1.l2_roles_ja ) As j1
    Cross Apply OpenJson ( j1.Value ) As j2
order by
    j2.[Key]
  , j2.Type
Go
*/
CREATE View ssas.model_json_35_roles
As
Select
    T1.databasename
  , j2.roles_name
  , j2.roles_members_ja
  , j2.roles_modelPermission
  , j2.roles_tablePermissions_ja
From
    ssas.model_json_20                      As T1
    Cross Apply OpenJson ( T1.l2_roles_ja ) As j1
    Cross Apply
    OpenJson ( j1.Value )
    With
    (
        roles_name NVarchar ( 500 ) N'$.name'
      , roles_members_ja NVarchar ( Max ) N'$.members' As Json
      , roles_modelPermission NVarchar ( 500 ) N'$.modelPermission'
      , roles_tablePermissions_ja NVarchar ( Max ) N'$.tablePermissions' As Json
    ) As j2