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


VIEW: SYS.DBA_CREDENTIALS

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

All credentials in the database

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128) Yes Owner of the credential
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 OWNER
,      CREDENTIAL_NAME
,      USERNAME
,      WINDOWS_DOMAIN
,      COMMENTS
,      ENABLED
FROM SYS.DBA_CREDENTIALS;

Dependencies

[top of page]

SYS.DBA_CREDENTIALS references the following:

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

SchemaPUBLIC
SynonymDBA_CREDENTIALS