My Oracle Support Banner

RDBPROD: RDB-E-NO_PRIV, Privilege Denied By Database Facility Error After Adding Computed By Field (Doc ID 860292.1)

Last updated on AUGUST 09, 2018

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.0 and later
HP OpenVMS Itanium
HP OpenVMS VAX
HP OpenVMS Alpha

Symptoms

After adding a computed by field:

RECORD_ID BIGINT
Computed: Automatic insert as record_id.nextval primary_key

to a table, users are no longer able to insert data into the table and the error

%RDB-E-NO_PRIV, privilege denied by database facility

is generated.

Changes

The added computed by field requires the use of an Rdb Sequence Object.  Although the users have access to the table they do not automatically get access to the SEQUENCE.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.