Reference apex_workspace_apex_users or wwv_flow_fnd_user in a foreign key constraint
0
votes
0
answers
941
views
What I'm trying to do is to extend authorisation upon APEX basic users to use it as conditions of pages rendering. I would like to create additional tables to store some workspace specific info about users. Is it possible to reference
wwv_flow_fnd_user.user_name
or apex_workspace_apex_users.user_name
as a foreign key
constraint? If yes, how to? If no, what's the alternative to bind APEX user info with my own additional info on database level?
I've tried:
- CONSTRAINT FK_USER_NAME FOREIGN KEY (USER_NAME) REFERENCES apex_workspace_apex_users (USER_NAME) ON DELETE CASCADE
- CONSTRAINT FK_USER_NAME FOREIGN KEY (USER_NAME) REFERENCES wwv_flow_fnd_user (USER_NAME) ON DELETE CASCADE
- CONSTRAINT FK_USER_NAME FOREIGN KEY (USER_NAME) REFERENCES APEX_190100.wwv_flow_fnd_user (USER_NAME) ON DELETE CASCADE
All of this both as SYSDBA and as an owning schema of an APEX workspace. All I've got so far is a bunch of errors like insufficient priviliges
and table or view does not exist
.
Asked by tsilvs
(160 rep)
Apr 30, 2019, 10:23 AM
Last activity: Apr 30, 2019, 10:36 AM
Last activity: Apr 30, 2019, 10:36 AM