To define a separate user
||On the Database tab, choose the Separate Properties for
Repository and Application option box and click this button to
define database properties separately for repository tables and
||Click the Define button to open the Separate Properties for
Repository and Application dialog.
||Create user USREP in the database which will contain the
||Create user USAPP in the database which will contain the
||Create a Binder item for 'Separate Properties for Repository
||Create Authorizer tables in USREP, by switching the Authorize
for Repository option ON. This option is a property of the
||Create Authorizer tables in USAPP, by switching the Authorize
for Repository option OFF. This option is a property of the
||Create Definer tables in USREP.
||Open the Authorizer of USAPP and create the application
TESTAPP. The owner is USAPP who is a member of the usergroup
||Define your application tables in the Definer and create
tables. The database application tables can be found in USAPP.
||Open the Windows Designer (TESTAPP) to create and paint
If the application TESTAPP is opened from within the data
dictionary, an error message will appear: "Cannot find a proper
repository for USAPP" and you will not be able to view your painted
In order to able to view your
painted classes, add to the 'Special' field in the application
properties, the following (WD) settings:
-wdrdbms OraLogin wddatabase "<Local>"
wdu USREP wdowner USREP wdpw USREP