Oracle 视图 ALL_SCHEDULER_CREDENTIALS 官方解释,作用,如何使用详细说明

本站中文解释

,任务调度存取控制凭据

Oracle视图ALL_SCHEDULER_CREDENTIALS描述了数据库中所有任务调度凭据。ALL_SCHEDULER_CREDENTIALS中的每一行都包含一个存取控制凭据名称以及它们外部资源(比如Windows或共享文件系统)所需要的所有控制信息。

运行此视图时,需要具有SCHEDULER_ADMIN角色的权限或SELECT_CATALOG_ROLE角色的权限。

使用此视图的主要目的是进行安全管理和授权控制。它还可以被用来验证数据库调度程序正确配置,以及任务调度程序是否与外部资源正确集成。

官方英文解释

ALL_SCHEDULER_CREDENTIALS displays information about the credentials accessible to the current user (that is, those credentials that the user has ALTER or EXECUTE privileges for).

Note:

This view is deprecated in favor of the ALL_CREDENTIALS view. Oracle recommends that you use ALL_CREDENTIALS instead. ALL_SCHEDULER_CREDENTIALS is retained for backward compatibility only.

Related Views

  • DBA_SCHEDULER_CREDENTIALS displays information about all credentials in the database.

  • USER_SCHEDULER_CREDENTIALS displays information about the credentials owned by the current user. This view does not display the OWNER column.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

NOT NULL

Owner of the Scheduler credential

CREDENTIAL_NAME

VARCHAR2(128)

NOT NULL

Name of the Scheduler credential

USERNAME

VARCHAR2(128)

Name of the user that will be used to log in to the remote database or operating system

DATABASE_ROLE

VARCHAR2(9)

For a database target, the database role to use when logging in:

  • SYSDBA

  • SYSOPER

WINDOWS_DOMAIN

VARCHAR2(30)

For a Windows target, the Windows domain to use when logging in

COMMENTS

VARCHAR2(4000)

Comments on the credential

See Also:

  • “ALL_CREDENTIALS”

  • “DBA_SCHEDULER_CREDENTIALS”

  • “USER_SCHEDULER_CREDENTIALS”


数据运维技术 » Oracle 视图 ALL_SCHEDULER_CREDENTIALS 官方解释,作用,如何使用详细说明