HPlogo ALLBASE/SQL Reference Manual: HP 9000 Computer Systems > Chapter 6 Names

Special Names

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

ALLBASE/SQL has several names with special meaning. You should not create objects with these names as owner:

  • TEMP— Modules owned by TEMP are deleted when the transaction in which they are created terminates.

  • CATALOG— This name is the owner of the catalog views.

  • SYSTEM— This name designates the owner of the system views.

  • HPRDBSS and STOREDSECT— These names designate the owners of the system tables. STOREDSECT owns the tables used to store compiled sections and views; HPRDBSS owns all other system tables.

  • PUBLIC— This name refers to all users and authorization groups who have been granted CONNECT authority.

  • HPODBSS— This name is reserved.

  • SEMIPERM— This name is the owner of all semi-permanent sections.

Feedback to webmaster