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:
- As the dbadmin, if the user does not exist, create the user with the command:
create user username identified by 'password';
-
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.
- As the dbadmin, grant the pulse_user role to the new user with the command:
grant pulse_users to username;
-
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.