ORA-01720: grant option does not exist for '.' Error Assigning Role to Table in Non OFSA 4.5 Schema
Last updated on JUNE 13, 2016
Applies to:Oracle Financial Data Manager - Version 4.5 to 4.5.40 [Release 4.5]
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) - Version: 4.5
Note: All OFSA 4.5 products have reached sustaining support.
On OFSA 4.5.36 when attempting to grant a role to a user defined table in a custom schema (not OFSA schema), the following error occurs:
ORA-01720: grant option does not exist for '.'
The issue can be reproduced at will with the following steps:
1. Created new table in COKI schema:
create table coki.coki_mortgage as select * from ofsademo.mortgages;
2. Registered new table in FDM (Wizards -> Register -> Object)
==> automatically created 'COKI_MORTGAGE_V'
3. Classify table as 'User Defined' in FDM
4. Attempt to assign table to role:
a. Wizards -> Security -> Role Assignment
b. Choose Role to Database Object Privileges
c. Choose the 'OFDM_R_CLIENT_PROC' role
d. 'User Defined' table from filter by table Classification
e. Check the boxes for select, insert, update and delete for the 'COKI_MORTGAGE_V'.
f. Hit Apply and the ORA-01720 error appears
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms