HP 3000 Manuals HP 3000 Manuals
User Access All HP ALLBASE/4GL user access to HP ALLBASE/SQL databases is controlled by the security provisions of HP ALLBASE/SQL, and is determined by the user's MPE/iX login name. This login name may not be the same as the user's HP ALLBASE/4GL name. The type of HP ALLBASE/SQL user access required for database users depends on the security requirements of the HP ALLBASE/4GL applications you are using. The HP ALLBASE/SQL access requirements for the various HP ALLBASE/4GL user types are summarized below. System Administrator The HP ALLBASE/4GL system administrator must be the database creator, or have database administrator authority (dba) for an application database. Application End Users. All application end users require connect authority for the application database. All application end users must have run authority for the module for the applications or versions they use. The module name is owner_group.name where owner_group is the SQL owner group for the application, and name is the name of the application or version. Application end users should not be members of the SQL owner group for the application. If they are members of this group, they will have authority to create, delete, or modify database tables and modules. Database Connect and Release HP ALLBASE/4GL connects to the application database environment automatically and also releases from the database environment automatically. In the run-time environment, HP ALLBASE/4GL connects to an application database automatically when the user executes a command that requires database access. HP ALLBASE/4GL then remains connected to the database for the duration of the HP ALLBASE/4GL session.