RDBPROD: RDB-E-NO_PRIV, Privilege Denied By Database Facility Error After Adding Computed By Field

(Doc ID 860292.1)

Last updated on JULY 29, 2016

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms