Database Vault: ORA-1031 When Using A WHERE Clause (Doc ID 1336044.1)

Last updated on JULY 10, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2.0 and later
Information in this document applies to any platform.

Goal

When Database Vault is enabled on a database you see the following results, you do not have to have any realms setup on the environment yet:

-- CONNECT AS ACCOUNT MANAGER:

CREATE USER A01 IDENTIFIED BY A01;
User created.

CREATE USER A02 IDENTIFIED BY A02;
User created.

GRANT CONNECT, RESOURCE TO A01;
Grant complete.

GRANT CONNECT, RESOURCE TO A02;
Grant complete.


-- CONNECT AS A01

CREATE TABLE TAB1 (A NUMBER(8), B VARCHAR2(20));
Table created.

INSERT INTO TAB1 VALUES (1, 'A');
1 row created.
INSERT INTO TAB1 VALUES (2, 'B');
1 row created.
INSERT INTO TAB1 VALUES (3, 'C');
1 row created.

GRANT DELETE ON TAB1 TO A02;
Grant complete.


-- CONNECT as A02

DELETE FROM A01.TAB1 WHERE A = 1
Error at line 3
ORA-01031: insufficient privileges

DELETE FROM A01.TAB1;
3 rows deleted.



Solution

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