Assign Users to the pulse_users Role and Allow Access to Pulse Functions

When you install Pulse, the install script creates a pulse schema, which contains the user-dictionary and mapping lists used by Pulse. Initially only administrators can read or edit tables in the pulse schema. To give non-administrator database users access to the pulse schema, you assign the user to the 'pulse_users' role, which has all privileges for the pulse schema. The role is created automatically when you install Pulse.

Note: The default dbadmin user has access to the pulse schema by default. You do not need to add the pulse_users role to the dbadmin account.

Granting users Access to the Pulse Schema

To grant non administrator users access to the tables in the Pulse schema:

  1. As the dbadmin, if the user does not exist, create the user with the command: create user username identified by 'password';
  2. As the dbadmin, if the user does not have access to function in the public schema, then grant execute privileges with the command: GRANT execute ON ALL FUNCTIONS IN SCHEMA public TO username;

    Note: By default, the Pulse functions are created in the public schema.

  3. As the dbadmin, grant the pulse_user role to the new user with the command: grant pulse_users to username;
  4. As the user to which you granted the pulse_user role, set the users role to pulse_users with the command: set role pulse_users;

    Note: The user must run the set role command per session to read or edit tables in the pulse schema.