Oracle Express Spreadsheet Add-In User's Guide
Release 6.3.4
Part Number A96501-01

B
Setting Security Levels for Database Attachment

Database Attachment Security Levels

Introduction

In certain cases, DBAs may wish to establish certain restrictions on the ability of users to attach Express databases. This appendix explains how to specify such security restrictions.

The LockOutRW property

The DBA can specify the security level for user database attachment by adding the LockOutRW property to the xpaddin.ini file. The following topic explains how to use the LockOutRW property to specify a security level.

Setting Security Levels Through the LockOutRW Property

Introduction

This topic explains how to use the LockOutRW property to specify security levels for user attachment of databases.

Using the LockOutRW property

To use the LockOutRW property to set security levels for database attachment, the DBA must define the property in the xpaddin.ini file as LockOutRW=n, where n is one of the following security level values.

Value	Description
0	There are no security restrictions. Users can attach databases in read/write or read-only mode. This is not the default setting. Therefore, to allow users to attach databases as read/write, the DBA must explicitly specify the LockOutRW property with a value of 0.
1	Users can attach databases only in read-only mode. This is the default setting. If no LockOutRW property is defined in the xpaddin.ini file, the Express Spreadsheet Add-In uses this setting.
2	Users cannot attach databases in any mode. If Financial Analyzer is already running when the user starts Excel, the user can use only the database that is currently attached; if Financial Analyzer is not already running, the user can use only the existing workbook.
3	In addition to setting the restrictions specified by security level 2, this security level makes the following functions unavailable to users: Express Wizard Selector Rotate Delete Data Row Delete Data Column

Oracle

Copyright © 1997, 2002 Oracle Corporation.
All Rights Reserved.