Naming Conventions

Overviews

Naming Conventions

Introduction

The LeasePak SETUP program allows the administrator 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.

Please refer to Environments and Databases and to LeasePak Roles for more information about the objects that are the focus of the naming conventions.

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 \| $NSTADMIN \| $NSTDBA	lpr[a-z][0-9_a-z]*	ora* \| syb* \| sys\| sa \| dba \| sysdba \| sso \| dbo $SRVADM \| $NSTADMIN \| $NSTDBA Unix/Linux account lpc \| lpt*

User

user

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

DBMS Roles

$SRVADM

Loose

Strict

Requires

Disallows

Requires

Disallows

[a-z][0-9_a-z]*

ora* | syb* | sys*| sa | dba | sysdba | sso | dbo
$SRVADM | $NSTADMIN | $NSTDBA
Unix/Linux account

[a-z][0-9_a-z]*

ora* | syb* | sys*| sa | dba | sysdba | sso | dbo
$SRVADM | $NSTADMIN | $NSTDBA
lpr* | lpc* | lpt*
Unix/Linux account

Administrator Roles

$NSTADMIN
$NSTDBA

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 \| $NSTADMIN \| $NSTDBA	[a-z][0-9_a-z]* Unix/Linux account	Directory Names ora* \| syb* \| sys\| sa \| dba \| sysdba \| sso \| dbo $SRVADM \| $NSTADMIN \| $NSTDBA lpr \| lpc* \| lpt*

Oracle Tablespace

ora-tsb; $MSIDB_SEG01

Loose		Strict
Requires	Disallows	Requires	Disallows
[a-z][0-9_a-z]*	ora* \| syb* \| sys*\| sa \| dba \| sysdba \| sso \| dbo	lp[ct][a-z][0-9_a-z]*	ora* \| syb* \| sys\| sa \| dba \| sysdba \| sso \| dbo lpr

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
cql	nst
data	ora
dataset	orcs
dlvy	owner
dsets	prg
	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, v61a)
lib	vertex
live	xlat