| Separator, special user, and group constants

Related topics
These constants can be used with methods in the wwsec_api Security API package methods: Separator constant is a character used to separate an object name from a site name in code that designates a Portal object by site ID and corner ID, as in '1/33'. Special user ID constants are used to confer schema owner and schema administration privileges. Special group ID constants are used to identify (preseeded) groups. Group owner constants indicate if a user or a group owns a specified object. Hidden group constants indicate if a group is hidden from all users and groups except those who are members of the group. Group site ID constants designates the site-wide availability of a group in a site.
Separator constant |
SITE_SEPARATOR varchar2(1) := ' / '; |
Special user ID constants |
SCHEMA_OWNER constant number(1) := 0; | SCHEMA_OWNER represents the user ID of the Portal administration user account created (pre-seeded) during the Portal installation. The name of this user account is the same as the name of the schema into which Oracle Portal was installed, e.g. PORTAL. This user account is a member of the DBA group when installed.
SCHEMA_ADMIN constant number(1) := 1; | SCHEMA_ADMIN represents the user ID of the Portal administration user account created (pre-seeded) during Portal installation. The name of this user account is derived by appending the string "_ADMIN" to the end of the schema name containing Oracle Portal, e.g. PORTAL_ADMIN. This user account is a member of the PORTAL_ADMINISTRATORS group when installed.
USER_PUBLIC constant number(1) := 2; | USER_PUBLIC represents the user ID of the public access user account. This entity does not represent a real user who can log in. It is used to identify an account that enables public access to certain objects in Oracle Portal. If this account is granted certain permissions on some Portal objects, those permissions automatically become available to all Portal users.
Special group ID constants |
GROUP_AUTHENTICATED_USERS constant number(1) := 0; | An authenticated user is a logged in user. GROUP_AUTHENTICATED_USERS is a group comprised of all logged in users. Every user who successfully connects to Portal after being authenticated by the Single Sign-On server is automatically granted membership in this group, if user is not already a member of the group. Hence, every logged in user automatically inherits any privileges granted to this group.
GROUP_DBA constant number(1) := 1; | GROUP_DBA is a privileged group. This group is granted privileges to all Portal objects. In addition, this group is also capable of administering users and groups in OID and creating schema objects.
GROUP_WEBDB_ADMINISTRATORS constant number(1) := 2; | This group is also a privileged group but its privileges form a subset of the privileges given to the DBA group. Specifically, the privileges to grant OID privileges to users and groups; edit or delete groups; and create schema objects are not granted to this group.
GROUP_PORTAL_PUBLISHERS constant number(1) := 3; | This group has the privileges to publish portlets.
GROUP_iPortal_ADMINISTRATORS constant number(1) := GROUP_WEBDB_ADMINISTRATORS; | See description for GROUP_WEBDB_ADMINISTRATORS above.
Group owner constants |
OWNER constant number(1) := 1; | An owner of a group has additional privileges on the group. The owner can edit or delete the group. An owner can be a user or a group. If a group is an owner of another group, all members of the owner group inherit the ownership.
NOT_OWNER constant number(1) := 0; | A user or group that is not an owner of a group.
Hidden group constants |
HIDDEN constant number(1) := 1; | A group that is hidden is visible only to its owners.
NOT_HIDDEN constant number(1) := 0; | A group that is not hidden can be seen by any user.
Group site ID constant |
GLOBAL_GROUP constant number(1) =: 0; | Prior to Oracle9iAS Portal 9.0.2, groups were scoped by site_id. This group scoping is not available in 9.0.2 or later. However, some APIs still include site_id for backward compatibility, although their implementation ignores any value that is passed. This constant can be used to pass site_id, if required by an API.

Related topics
Security API package | PDK PL/SQL API Reference - Home

Back to top
The PL/SQL API Reference is part of the Portal Developer Kit on Portal Studio