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


VIEW: SYS.USER_CREDENTIALS

Object Details
Object Name: USER_CREDENTIALS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Credentials owned by the current user

[View Source]

Columns
Name Datatype Length Mandatory Comments
CREDENTIAL_NAME VARCHAR2 (128) Yes Name of the credential
USERNAME VARCHAR2 (128)
User to run as
WINDOWS_DOMAIN VARCHAR2 (30)
Windows domain to use when logging in
COMMENTS VARCHAR2 (240)
Comments on the credential
ENABLED VARCHAR2 (5)
Is this credential enabled
Query Text

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


SELECT CREDENTIAL_NAME
,      USERNAME
,      WINDOWS_DOMAIN
,      COMMENTS
,      ENABLED
FROM SYS.USER_CREDENTIALS;

Dependencies

[top of page]

SYS.USER_CREDENTIALS references the following:

SchemaSYS
TableOBJ$
TableSCHEDULER$_CREDENTIAL
SYS.USER_CREDENTIALS is referenced by following:

SchemaPUBLIC
SynonymUSER_CREDENTIALS