Oracle Rest Data Services (ORDS) (MOSC)

MOSC Banner

insufficient INHERIT PRIVILEGES privilege

Error starting at line : 3 in command -
BEGIN
ORDS.ENABLE_SCHEMA(
p_enabled => TRUE,
p_schema => 'HR',
p_url_mapping_type => 'BASE_PATH',
p_url_mapping_pattern => 'hr',
p_auto_rest_auth => FALSE
);
COMMIT;
END;
Error report -
ORA-06598: ανεπαρκή δικαιώματα INHERIT PRIVILEGES
ORA-06512: σε "ORDS_METADATA.ORDS", γραμμή 1
ORA-06512: σε γραμμή 2
06598. 00000 - "insufficient INHERIT PRIVILEGES privilege"
*Cause: An attempt was made to run an AUTHID CURRENT_USER function or
procedure, or to reference a BEQUEATH CURRENT_USER view, and the
owner of that function, procedure, or view lacks INHERIT PRIVILEGES
privilege on the calling user.
*Action: Either do not call the function or procedure or reference the view,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center