Database Reference
In-Depth Information
Note If this were being used in production at the moment, you would grant the appropriate narrow privilege (as
shown) before revoking the inappropriate broader privilege in order to keep appropriate functions working during
the update.
Create the Remaining Structures for Application Authorization
The remainder of the NewSys.sql script for the apver instance configures all the structures we need to do
application authorization. Most of the structures are created in the appsec schema. To do this as SYS
user, we simply prefix the name of the structure we are creating with the schema name appsec.
We are doing this as SYS user to keep from granting administrative privileges to any other user, even
appsec . This is the most secure, but control of the SYS password is mandatory.
Before running the script, copy and paste over the wrapped functions, f_mask and f_unmask , with the
versions that you created and wrapped. Table 11-2 provides a list of the structures we will be creating, in
creation order.
Table 11-2. Structures Created in apver Instance
TABLE
APPSEC.T_APPSEC_ERRORS
TABLE
APPSEC.T_APPSEC_ERRORS_MAINT
PACKAGE
APPSEC.APP_SEC_PKG
PROCEDURE
APPSEC.P_APPSEC_ERRORS_JANITOR
TRIGGER
APPSEC.T_APPSEC_ERRORS_IAR
TABLE
APPSEC.T_TWO_FACT_CD_CACHE
PROFILE
APPVER_PROF
USER
APPVER
USER
OSUSER
USER
OSADMIN
TABLE
APPSEC.T_APPLICATION_REGISTRY
TABLE
APPSEC.T_APP_CONN_REGISTRY
TABLE
APPSEC.T_APPLICATION_KEY
 
Search WWH ::




Custom Search