Restriction on the sample SmUser and SmGroup Schema

Products

• SITEMINDER

Issue/Introduction

In the <policyserver_home>/db/SQL, sample user schemas are provided, such a file as 'smsampleusers_sqlserver.sql'. This article explains an important restriction on SmUser and  SmGroup Schema.

Environment

Policy Server: all version

Resolution

The column 'Name' is present in both SmUser and SmGroup tables (as shown below)  and it is mandatory to have this column common in both the tables. If you create your own user and group tables, you must follow this.

CREATE TABLE SmGroup (
        GroupID              int NOT NULL,
        Name                 SmStringReqN,
        PRIMARY KEY (GroupID)
 )

CREATE TABLE SmUser (
        UserID               int NOT NULL,
        Name                 SmStringReqN,
        Password             SmStringReqN,
        LastName             SmStringReqN,
        FirstName            SmStringReqN,
        EmailAddress         SmStringReqN,
        TelephoneNumber      SmStringReqN,
        Disabled             SmStringReqN,
        PIN                  SmStringReqN,
        Mileage              int NOT NULL,
        PasswordData         varchar(2000) NOT NULL,
        PRIMARY KEY (UserID)
 )