The P2K_USER role must be granted to each user who will connect to the application. This role grants access to the data base objects contained within the P2K schema (tables, functions, procedures, etc.).

This role is required for each user who would access the data through the Personality application.

It is not recommended that this role be granted as a Default Role as this would enable the users to access all the tables and the data therein when they connect with an external tool (such as SQL, Access or Discoverer) and bypass any security you may have defined. Granting DEFAULT ROLE status must be done with care.

This role should ALWAYS have a password on it.


Notes #

Click to create a new notes page