| |
 |
|
Oracle Tips by Burleson |
Environment Settings
The environment settings of HTML DB allow the
Administrator to control various aspects of the HTML DB
configuration. There are six configuration areas: Application
Development; Self Service; Email; SQL Workshop;
Monitoring; and Security.
Application Development
The Application Development section has two
different settings to be configured. These are depicted in Figure
15.2.
-
Allow PL/SQL Program Unit Editing: Turns off the
editing capability in the Object Browser of the SQL Workshop. The
administrator may want to keep control of the content of the
procedures, packages and functions and not allow every developer of
an application the ability to edit them
-
Create demonstration objects in new workspaces:
When HTML DB creates a new workspace, it will also create a
demonstration application in the workspace if the Create
demonstration objects in new workspaces option is set to YES.
Setting this option to NO will prevent their creation. This would
be set to NO for production environments.
Self Service
The Self Service section, shown in Figure 15.3,
controls how the requests for workspaces are handled. If the
Provisioning Status is set to MANUAL, the request link will not show
on the login page for users to request a workspace. In this case, the
administrator would create each workspace by hand. If set to REQUEST,
the link will show on the login page and the request will go into the
queue for approval. If approved, the Development Service URL will be
sent in the email back to the user as the URL to use for login. If no
URL is entered, one will be derived from the environment
automatically.
Email
The Email section configures how HTML DB will
interface with the SMTP email service. These settings will allow HTML
DB to send email to the user when an email request has been made. The
SMTP Host Address can be set to the local server or it can utilize
another server. SMTP Host Port is set to the default for the SMTP
server which is 25. Only change this setting if necessary. Lastly,
the Administration Email Address is the address used to send email to
the user. This is the FROM address.
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
