ENABLE_WORKSPACE_USER Procedure

205.3.1 ENABLE_WORKSPACE_USER Procedure

This procedure enables an existing database user as an ingest, a query user, or both for a Oracle AI Database Telemetry Streaming workspace.

Syntax

enable_workspace_user(
       workspace_name IN VARCHAR2,
       user_name      IN VARCHAR2,
       user_role      IN VARCHAR2);

Parameters

Table 205-2 ENABLE_WORKSPACE_USER Procedure Parameters

Parameter Description

Parameter	Description
`workspace_name`	Name of the workspace to which an existing database user needs to be enabled
`user_name`	Name of an already existing database user who needs to be enabled in the workspace as an ingest user, query user, or both. Ingest user and query user names can be any valid database user names and can contain non-ASCII characters.
`user_role`	The `user_role` can be one of the following: 'INGEST', 'QUERY', 'INGEST\|QUERY'

workspace_name

Name of the workspace to which an existing database user needs to be enabled

user_name

Name of an already existing database user who needs to be enabled in the workspace as an ingest user, query user, or both.

Ingest user and query user names can be any valid database user names and can contain non-ASCII characters.

user_role

The user_role can be one of the following: 'INGEST', 'QUERY', 'INGEST|QUERY'

Note:

Multiple workspaces cannot have the same user assigned to them. An error is returned if the user_name does not exist or is already associated with another workspace.