Naming Conventions

Introduction

The LeasePak setup program allows you to choose between loose and strict naming conventions. During setup, you will be prompted to select one of the following:

S=Strict
L=Loose
N=New Strict

If you have an existing installation of LeasePak version 5.0a or below, select L for Loose to use old naming conventions on existing data and Loose conventions on new data, or select N for New Strict to use old naming conventions on existing data but Strict conventions on new data.

If you have an existing installation of LeasePak version 5.1a or above, or you are installing LeasePak for the first time, select S to use Strict conventions, select L to use Loose conventions, or select N if you have previously used Loose conventions but want to switch to Strict for new data.

Loose and Strict Conventions

Use the following tables to determine the Loose or Strict conventions for each name type.

Naming conventions use regular expressions to denote variable characteristics.

Environment Name

`env-name; $ENVNAME`

Loose		Strict
Requires	Disallows	Requires	Disallows
`[a-z][-0-9_a-z]*`		`[a-z][-0-9_a-z]*`	Directory Names `ora* \| syb* \| sys\| sa \| dba \| sysdba \| sso \| dbo` `lpr` `lpc* \| lprt*`

Database Name and Owner

`database-name; $MSIDB_DBNAME`

`dbo; $MSIDB_OWNER`

Loose		Strict
Requires	Disallows	Requires	Disallows
`[a-z][0-9_a-z]*`	`ora* \| syb* \| sys*\| sa \| dba \| sysdba \| sso \| dbo` `$SRVADM \| $SRVSO \| MSIADMIN \| MSIDBA`	`[a-z][0-9_a-z]*` `lpr` prefix	`ora* \| syb* \| sys*\| sa \| dba \| sysdba \| sso \| dbo` `$SRVADM \| $SRVSO \| MSIADMIN \| MSIDBA` Unix/Linux account `lpc/lpt` prefixes

User

`user`

Loose		Strict
Requires	Disallows	Requires	Disallows
`[a-z][0-9_a-z]*`	`ora* \| syb* \| sys*\| sa \| dba \| sysdba \| sso \| dbo` `$SRVADM \| $SRVSO \| MSIADMIN \| MSIDBA`	`[a-z][0-9_a-z]*` Unix/Linux account	`ora* \| syb* \| sys*\| sa \| dba \| sysdba \| sso \| dbo` `$SRVADM \| $SRVSO \| MSIADMIN \| MSIDBA` `lpr` prefix `lpc/lpt` prefixes

DBMS Roles

`$SRVADM`

`$SRVSO`

Loose		Strict
Requires	Disallows	Requires	Disallows
`[a-z][0-9_a-z]*`	`ora* \| syb* \| sys*\| sa \| dba \| sysdba \| sso \| dbo` `$SRVADM \| $SRVSO \| MSIADMIN \| MSIDBA`	`[a-z][0-9_a-z]*` Unix/Linux account	`ora* \| syb* \| sys*\| sa \| dba \| sysdba \| sso \| dbo` `$SRVADM \| $SRVSO \| MSIADMIN \| MSIDBA` `lpr` prefix `lpc/lpt` prefixes

Administrator Roles

`$MSIADMIN`

`$MSIDBA`

Loose		Strict
Requires	Disallows	Requires	Disallows
`[a-z][0-9_a-z]*` Unix/Linux account	Directory Names `ora* \| syb* \| sys*\| sa \| dba \| sysdba \| sso \| dbo` `$SRVADM \| $SRVSO \| MSIADMIN \| MSIDBA`	`[a-z][0-9_a-z]*` Unix/Linux account	Directory Names `ora* \| syb* \| sys*\| sa \| dba \| sysdba \| sso \| dbo` `$SRVADM \| $SRVSO \| MSIADMIN \| MSIDBA` `lpr` prefix `lpc/lpt` prefixes

Oracle Tablespace

`ora-tsb; $MSIDB_SEG01`

Loose		Strict
Requires	Disallows	Requires	Disallows
`[a-z][0-9_a-z]*`	`^.[0-9][0-9]$` `ora \| syb* \| sys*\| sa \| dba \| sysdba \| sso \| dbo`	`[a-z][0-9_a-z]*` `lpc/lpt` prefixes	`^.[0-9][0-9]$` `ora \| syb* \| sys*\| sa \| dba \| sysdba \| sso \| dbo` `lpr` prefix

Disallowed Directory Names

Where specified, both the Loose and Strict naming conventions disallow using the following directory names for other name types:

bin        log  
bld        lp
conv       msi
data       ora
dataset    orcs
dlvy       owner
dset       r2k
env        sbin
eop        seed
err        sql
etc        std
exe        syb
gen        sys	
host       temp
html       test
lease      tmp
level      v[0-9][0-9][a-z] (for example, ) 
lib        vertex 
live       xlat

The information contained in this document is the property of McCue Systems, Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. McCue Systems, Inc. assumes no liability for any inaccuracy that may appear in this document; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of McCue Systems, Inc. is prohibited.