HP 3000 Manuals HP 3000 Manuals
HP ALLBASE/SQL Database Security Each application may only access one HP ALLBASE/SQL database. For simplicity, the database details for an application are entered as part of the application definition details. All access to HP ALLBASE/SQL databases is subject to the normal security provisions of HP ALLBASE/SQL. Application developers require CONNECT authority and RESOURCE authority to be able to create tables in the database environment. End users require CONNECT authority and RUN authority for the database module for an application. End users may also require additional access authority for tables or views in the database. The MPE/iX user who creates the database with HP ISQL automatically becomes the database administrator. This user must grant the appropriate authorities to other users. You may specify an SQL owner group for the database on the application definition screen. HP ALLBASE/4GL transfers ownership of all SQL tables created in the application to this owner group. HP ALLBASE/4GL also transfers the ownership of database modules for the application to this owner group. Don't attempt to change the name of the SQL owner group for an application after development for the application has commenced.