Administration Authorities

Administration authorities enable users to perform well-defined sets of database administration tasks.

For an overview of authorities that affect both simplex and multiplex servers, see System Administration Guide: Volume 1 > Managing User IDs and Permissions > Database Permissions and Authorities Overview.

• MULTIPLEX ADMIN Authority
  MULTIPLEX ADMIN authority allows a user without DBA authority to perform multiplex administration tasks.
• Using Multiplex Procedures for Tailored Security
  For strict security, you can disallow all access to underlying tables, and grant permissions to users or groups of users to execute certain stored procedures. This approach strictly defines who can define data in the database.
• Granting Users the Permissions to Run Related Stored Procedures
  When you create a new user who is to be granted an authority, grant membership for this user to the group created for that authority. Since most authorities are inherited through group membership, the user inherits the authority and also the execute permissions for the IQ procedures from the group.