eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: HR.PER_SECURITY_USERS

Object Details

Object Name:	PER_SECURITY_USERS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.PER_SECURITY_USERS
Subobject Name:
Status:	VALID

When users logon to a HRMS security profile, by virtue of their responsibility being attached to a security profile, their security permissions are evaluated dynamically if user-based security features are being used (supervisor hierarchy security, user-based organization security, etc.). This evaluation can affect logon performance for users that have access to many people. PER_SECURITY_USERS stores a list of users for a particular security profile. During Security List Maintenance, these users will have their access permissions pre-evaluated and stored in static lists for quick retrieval during logon.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_SECURITY_USERS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	SECURITY_USER_ID
PER_SECURITY_USERS_UK2	NORMAL	UNIQUE	APPS_TS_TX_IDX	USER_ID SECURITY_PROFILE_ID
PER_SECURITY_USERS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SECURITY_PROFILE_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PER_SECURITY_USERS		PER_SECURITY_PROFILES	PER_SECURITY_USERS SECURITY_PROFILE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SECURITY_USER_ID	NUMBER	(15)	Yes	System-generated primary key column.
SECURITY_PROFILE_ID	NUMBER	(15)	Yes	Foreign key to PER_SECURITY_PROFILES.
USER_ID	NUMBER	(15)	Yes	Foreign key to FND_USER.
OBJECT_VERSION_NUMBER	NUMBER	(15)	Yes	System-generated version of row. Increments by one with each update.
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column.
LAST_UPDATE_DATE	DATE			Standard Who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
CREATED_BY	NUMBER	(15)		Standard Who column.
CREATION_DATE	DATE			Standard Who column.
PROCESS_IN_NEXT_RUN_FLAG	VARCHAR2	(30)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SECURITY_USER_ID
,      SECURITY_PROFILE_ID
,      USER_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      PROCESS_IN_NEXT_RUN_FLAG
FROM HR.PER_SECURITY_USERS;

Dependencies

[top of page]

HR.PER_SECURITY_USERS does not reference any database object

HR.PER_SECURITY_USERS is referenced by following:

HR: PER_SECURITY_USERS#