nifi-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From GitBox <...@apache.org>
Subject [GitHub] [nifi-registry] kevdoran commented on a change in pull request #232: NIFIREG-292 Add DB impls of UserGroupProvider and AccessPolicyProvider
Date Wed, 16 Oct 2019 19:44:13 GMT
kevdoran commented on a change in pull request #232: NIFIREG-292 Add DB impls of UserGroupProvider
and AccessPolicyProvider
URL: https://github.com/apache/nifi-registry/pull/232#discussion_r335634321
 
 

 ##########
 File path: nifi-registry-core/nifi-registry-framework/src/main/resources/db/migration/default/V8__AddUserGroupPolicy.sql
 ##########
 @@ -0,0 +1,62 @@
+-- Licensed to the Apache Software Foundation (ASF) under one or more
+-- contributor license agreements.  See the NOTICE file distributed with
+-- this work for additional information regarding copyright ownership.
+-- The ASF licenses this file to You under the Apache License, Version 2.0
+-- (the "License"); you may not use this file except in compliance with
+-- the License.  You may obtain a copy of the License at
+--
+--     http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing, software
+-- distributed under the License is distributed on an "AS IS" BASIS,
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+-- See the License for the specific language governing permissions and
+-- limitations under the License.
+
+-- UserGroupProvider tables
+
+CREATE TABLE UGP_USER (
+    IDENTIFIER VARCHAR(50) NOT NULL,
+    IDENTITY VARCHAR(4096) NOT NULL,
+    CONSTRAINT PK__UGP_USER_IDENTIFIER PRIMARY KEY (IDENTIFIER),
+    CONSTRAINT UNIQUE__UGP_USER_IDENTITY UNIQUE (IDENTITY)
+);
+
+CREATE TABLE UGP_GROUP (
+    IDENTIFIER VARCHAR(50) NOT NULL,
+    IDENTITY VARCHAR(4096) NOT NULL,
+    CONSTRAINT PK__UGP_GROUP_IDENTIFIER PRIMARY KEY (IDENTIFIER),
+    CONSTRAINT UNIQUE__UGP_GROUP_IDENTITY UNIQUE (IDENTITY)
+);
+
+CREATE TABLE UGP_USER_GROUP (
+    USER_IDENTIFIER VARCHAR(50) NOT NULL,
+    GROUP_IDENTIFIER VARCHAR(50) NOT NULL,
+    CONSTRAINT PK__UGP_USER_GROUP PRIMARY KEY (USER_IDENTIFIER, GROUP_IDENTIFIER),
+    CONSTRAINT FK__UGP_USER_GROUP_USER_IDENTIFIER FOREIGN KEY (USER_IDENTIFIER) REFERENCES
UGP_USER(IDENTIFIER) ON DELETE CASCADE,
 
 Review comment:
   This FK constraint prevents us from doing something like CompostUGP(LDAP,DB) and creating
DB groups with LDAP users. Is that a supported deployment configuration?

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

Mime
View raw message