SecMigrate.exe Deletes Features - Datasource permissions when Run on Security Database (Doc ID 1470345.1)

Last updated on OCTOBER 06, 2022

Applies to:

Symptoms

When the SecMigrate.exe facility is run on a security database it deletes all the custom and datasource permissions.

EXPECTED BEHAVIOR
-----------------------
1. The SecMigrate facility should be run to convert the v4.53 database schema to the 1.5 version.
2. This executable takes each of the user/group clobs for features out of the database. It looks for old privileges and replaces them with new privileges. For any patterns that is does not recognize, it leaves it alone. Then it replaces the old clob with the new clob.
3. This is only for features. The data side should be identical. Even the features->data access is the same as in earlier versions.
4. It does nothing with table security.
5. It will leave custom security alone, so custom XSDs would not be changed during an upgrade.
 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Connect lssecure.cfg.xml to a security db
2. Secure the account table under the datasource - features menu
3. Add a user and gave permissions to the account table under the features - datasource menu item (eg. insert, update, delete)
4. Ran SecMigrate on this database
5. Refresh the user permissions - there are no longer any boxes checked under the features - datasource - account item.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.