Security Framework Guide

10.1
- 10.5 HotFix 2
- 10.5 HotFix 1
- 10.5
- 10.2 HotFix 1
- 10.2
- 10.0 HotFix 1
- 10.0

Back Next

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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

Configuration Tasks

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.

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

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

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

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

Back Next

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Security Framework Guide

Security Framework Guide

Configuring Database

Configuring Database

Download and Install JDBC Library