IBM Support

How to set up field level security in iBase

How To


Summary

I want to use field security in iBase. I'm following the instructions in the documentation, but the field security options are not appearing when adding an entity.

Objective

Field level security allows you to set a classification level on a record, which determines who can view it.

Environment

iBase

Steps

The documentation does instruct on how to enable field security, but sometimes it's easier to see the steps with images.  This cookbook approach is using our example "User Guide" database.
  1. Open iBase Designer and log in as an administrator.  Open your database.
  2. Ensure that your database is upsized to SQL Server.  Click File-->Database Properties.  Confirm database type is "SQL Server".
    image 10376
  3. Still in Database Properties, click the "Advanced" tab.  Select "Standard (SCC) Control" and check "Restrict SCC lists to accessible items only". Close Database Properties by clicking "OK".
    image 10377
  4. Navigate to "Code Lists"-->"SCC Lists".  Right-click and select "New".
    image 10378
  5. Give your new SCC List a name, and populate it with your required security levels.  Click "OK" to save.
    image 10379
  6. In the menu bar, click "Security"-->"Security Manager".
    image 10381
  7. Under the "Groups" tab, expand "Data Access Control".  Add any groups that you are using to determine access level.  Close Security Manager.
    image 10382
  8. On the menu, click "Security"-->"Data Access Control".  
    image 10380
  9. On the "Security Classification Codes" tab, select each Security Group, and click the Security Classification Codes for each group.  Important: These are the levels for which the group are denied access.  Click OK to save and close.
    image 10383
  10. On your entity or link, create a new field to be classified.
    image 10387
  11. Fill in the information for the new field.  "Type" must be "Security Classification Code", and the "Code List" is the list you defined in step 5.  Setting a Default Value is optional. Click OK.
    image 10404
  12. Close your database in iBase Designer, and open it in iBase user.  Create a new entity.  Now you can set the security classification value for that record.
    image 10405

Related Information

iBase enabling field security

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB24","label":"Security Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSXW43","label":"i2 iBase"},"ARM Category":[{"code":"a8m0z000000bo5KAAQ","label":"i2 iBase and i2 Analyst's WorkStation->Install\/Configure\/Upgrade"}],"ARM Case Number":"TS005814219","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Document Information

Modified date:
08 June 2021

UID

ibm16459951

Page Feedback