Overview of access authorization to a SESAM/SQL database

Authorization	creating with	Parameter	Specification
User authorized for the CREATE CATALOG statement	DBH option	ADMINISTRATOR=...	a new system user ID
the universal user	ESQL program Utility Monitor	CREATE CATALOG USER=... PASSWORD=...	the first system entry
BS2000 password for the database	ESQL program Utility Monitor		BS2000 password
SQL user	ESQL program Utility Monitor	CREATE USER CREATE SYSTEM_USER	a new authorization identifier a new system entry (system user ID, authorization identifier)

Table 41: Creating new SQL users in SESAM/SQL and assigning BS2000 passwords

Authorization	identifying in	Parameter	Specification
Authorization keys for SQL users	Precompiler option	SOURCE- PROPERTIES- AUTHORIZATION=...	Authorization identifier
	Configuration file, or relevant screen in utility monitor	SEE-AUTHID=... parameter for utility monitor	Authorization identifier
	ESQL program utility monitor	SET SESSION AUTHORIZATION	Authorization identifier
BS2000 password for the database	DBH start statement	ADD-SQL- DATABASE- CATALOG-LIST ... PASSWORD=...	BS2000 password

Table 42: Identifying SQL users in SESAM/SQL and specifying the BS2000 password