HP 3000 Manuals HP 3000 Manuals
Granting Authorities to Access ALLBASE/SQL Tables
After Access SQL/iX is installed, you must grant certain authorities to
your Information Access users to allow them to access ALLBASE/SQL tables.
These authorities are:
* CONNECT to a DBEnvironment
* SELECT on system.table
* SELECT on system.column
* SELECT on system.group
* SELECT on system.specauth
* SELECT on system.tabauth
The CONNECT authority enables the user to access data from one or more
tables in a particular DBEnvironment.
The SELECT authorities are on five tables in the ALLBASE/SQL system
catalog. These authorities are necessary so that Access SQL/iX can
generate the list of tables and views to which the user has access.
PC users who have DBA authority can access these system catalog tables as
well as other system tables. The tables will be listed on the Remote
Tables screen in the Tables box in Information Access. PC users who do
not have DBA authority will not see these system catalog tables listed
nor can they access them through Information Access. However, they can
access them through ISQL, the facility provided by ALLBASE/SQL for
interactively accessing and using ALLBASE/SQL databases and tables.
The process for granting these authorities to your users has
been automated for you by the inclusion of the ISQL command file
IAGRANT.PPC.SYS with Access SQL/iX. You can use this command file for
granting authorities to a single user or to a group of users who need the
same authorities. Instructions for using this command file follow this
section.
Additionally, you need to grant each PC user SELECT authority to each
table the user will access in Information Access. All tables to which
the PC user has SELECT authority will be listed in the Tables box in
Information Access.
See Chapters 4 and 5 of the ALLBASE/SQL Database Administration Manual
for 900 Series HP 3000 Computer Systems for detailed information on
granting authorities to ALLBASE/SQL users.
The IAGRANT.PPC.SYS Command File
The command file IAGRANT.PPC.SYS looks like this:
set echo on;
set continue on;
grant connect to &1;
grant select on system.table to &1;
grant select on system.column to &1;
grant select on system.group to &1;
grant select on system.specauth to &1;
grant select on system.tabauth to &1;
commit work;
You need to run this file for each Information Access user or group .
To use IAGRANT.PPC.SYS:.
1. Run ISQL.
2. Connect to the desired DBEnvironment.
3. Run the IAGRANT.PPC.SYS file by typing:
START IAGRANT.PPC.SYS (username or groupname);
where username is the SQL user for whom you are granting
authorities (for example, USR@ACCT) or where groupname is a group
of users for whom you are granting authorities.
4. The ISQL prompt reappears when the command file has executed.
5. Run IAGRANT.PPC.SYS for each user or group as needed.
Remember to use this command file whenever you add new Information Access
users who will be accessing ALLBASE/SQL data.