广州明生医药有限公司


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

网络编程 Oracle 视图 ALL_SCHEDULER_CREDENTIALS 官方解释,作用,如何使用详细说明 10-18

本站中文解释

,任务调度存取控制凭据

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.

ColumnDatatypeNULLDescription

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”


编辑:广州明生医药有限公司

标签:凭据,视图,角色,权限,正确