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: IBC.IBC_GRANTS

Object Details

Object Name:	IBC_GRANTS
Object Type:	TABLE
Owner:	IBC
FND Design Data:	IBC.IBC_GRANTS
Subobject Name:
Status:	VALID

Permissions given for a particular object.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IBC_GRANTS_N01	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_ID GRANT_GROUP_ID PERMISSION_CODE ACTION
IBC_GRANTS_N02	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GRANT_GROUP_ID OBJECT_ID ACTION

Columns

Name	Datatype	Length	Mandatory	Comments
GRANT_ID	NUMBER		Yes	Grants unique identifier
OBJECT_ID	NUMBER		Yes	Permission's Object Type. Reference object_id in FND_OBJECTS
PERMISSION_CODE	VARCHAR2	(30)	Yes	It needs to be defined as a value for the lookup type defined in IBC_OBJECT_PERMISSIONS for specific object id.
GRANTEE_USER_ID	NUMBER			Reference to FND_USER. User who receives the grant. If GRANTEE_USER_ID has a value then GRANTEE_RESOURCE_ID and GRANTEE_RESOURCE_TYPE must be empty.
GRANTEE_RESOURCE_ID	NUMBER			GRANTEE_RESOURCE_ID and GRANTEE_RESOURCE_TYPE make reference to JTF_RS_ALL_RESOURCES_VL. They identify the resource receiving the grant.
GRANTEE_RESOURCE_TYPE	VARCHAR2	(30)		Grantee Resource Type
GRANT_GROUP_ID	NUMBER		Yes	Link to the group of grants (IBC_GRANT_GROUPS)
ACTION	VARCHAR2	(30)	Yes	Grant Action. Valid values are "ALLOW" or "RESTRICT".
GRANT_LEVEL	NUMBER		Yes	Grant's level of inheritance. A value of zero (0) means that the grant was given at current level.
CASCADE_FLAG	VARCHAR2	(1)	Yes	Flag to signal whether current grant needs to be cascaded through the inheritance tree. Valid values are Y or N.
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object version number for locking.
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SECURITY_GROUP_ID	NUMBER			Security Group Identifier.

Query Text

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


SELECT GRANT_ID
,      OBJECT_ID
,      PERMISSION_CODE
,      GRANTEE_USER_ID
,      GRANTEE_RESOURCE_ID
,      GRANTEE_RESOURCE_TYPE
,      GRANT_GROUP_ID
,      ACTION
,      GRANT_LEVEL
,      CASCADE_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM IBC.IBC_GRANTS;

Dependencies

[top of page]

IBC.IBC_GRANTS does not reference any database object

IBC.IBC_GRANTS is referenced by following:

APPS: IBC_GRANTS