Security Framework Guide

Security Framework Guide

Configuring Database

Configuring Database

MDM Registry Edition supports Oracle, Microsoft SQL Server, and IBM DB2 UDB databases. Configure the security framework to use the security information from the database or use the following default metadata, which is required to configure the framework appropriately.
You can find the scripts to create the required tables for different databases in the
$SSATOP/security/scripts
directory.
Users
Column
Type
Description
REC_NO
INTEGER
The record index and is the primary key.
ID
VARCHAR(32)
User identifier. It must be unique.
FIRST_NAME
VARCHAR(64)
First name of the user.
LAST_NAME
VARCHAR(64)
Last name of the user.
EMAIL
VARCHAR(255)
Email address of the user.
PASSWORD
VARCHAR(512)
User's password.
Roles
Column
Type
Description
REC_NO
INTEGER
The record index and is the primary key.
ID
VARCHAR(32)
Role identifier. It must be unique.
DESCRIPTION
VARCHAR(255)
Description about the role.
Resources
Column
Type
Description
REC_NO
INTEGER
The record index and is the primary key.
ID
VARCHAR(32)
Resource identifier. It must be unique.
DESCRIPTION
VARCHAR(255)
Description about the resources.
Privileges
Column
Type
Description
REC_NO
INTEGER
The record index and is the primary key.
ID
VARCHAR(32)
Privilege identifier. It must be unique.
DESCRIPTION
VARCHAR(255)
Description about the privilege.
Groups
Column
Type
Description
REC_NO
INTEGER
The record index and is the primary key.
ID
VARCHAR(32)
Group identifier. It must be unique.
DESCRIPTION
VARCHAR(255)
Description about the group.
Permissions
Column
Type
Description
REC_NO
INTEGER
The record index and is the primary key.
ID
VARCHAR(32)
Permission identifier. It must be unique.
RESOURCE_ID
INTEGER
Reference to resource record.
DESCRIPTION
VARCHAR(255)
Description about the permission.
Privileges of permission
Column
Type
Description
PERMISSION_ID
INTEGER
Reference to permission record.
PRIVILEGE_ID
INTEGER
Reference to privilege record.
User to role
Column
Type
Description
USER_ID
INTEGER
Reference to user record.
ROLE_ID
INTEGER
Reference to role record.
User to group
Column
Type
Description
USER_ID
INTEGER
Reference to user record.
GROUP_ID
INTEGER
Reference to group record.
Roles to permissions
Column
Type
Description
ROLE_ID
INTEGER
Reference to role record.
PERMISSION_ID
INTEGER
Reference to permission record.
To create schema, use the following commands:
For Oracle:
sqlplus <user>/<password>@service @secora.sql
For Microsoft SQL Server:
sqlcmd -U <User Id> -P <Password> -S <Server> -i secmsq.sql
For IBM DB2 UDB:
  • Edit the
    secudb.sql
    file and update the line
CONNECT TO <service>USER <user> USING "<password>";
db2 -tf secudb.sql

Download and Install JDBC Library

The Security Framework requires JDBC libraries to connect to the database. You must download and install the appropriate JDBC libraries from your database vendor.
  1. Based on the database, download the required libraries.
    The following table lists the required libraries for each supported database:
    Database
    Library Names
    DB2
    db2jcc.jar
    Oracle
    ojdbc5.jar
    Orai18n.jar
    dms.jar
    Microsoft SQL
    sqljdbc4 .jar
  2. Copy the library files to the following directory:
    • On Windows.
      <MDM Registry Edition Installation Directory>\security\lib
    • On UNIX.
      <MDM Registry Edition Installation Directory>/security/lib
  3. If you use Oracle, copy the
    dms.jar
    file to the following directory:
    • On Windows.
      <MDM Registry Edition Installation Directory>\tomcat\lib
    • On UNIX.
      <MDM Registry Edition Installation Directory>/tomcat/lib

0 COMMENTS

We’d like to hear from you!