ORA-41900: missing UPDATE privilege on "OWNER"."TABLE"

ORA-41900: missing UPDATE privilege on "LAB_B"."PRICE"

You used a table owned by another user without the object privilege that statement needs.

Lab-verifiedReproduced and fixed on Oracle AI Database 26ai Free 23.26.3.0.0 · 2026-11-15

ORA-41900 is new in Oracle 23ai. When you lack an object privilege on someone else's table, 23ai names the missing privilege and the table, e.g. missing UPDATE privilege on "LAB_B"."PRICE". Older versions raised ORA-01031: insufficient privileges for the same situation.

Check what you received with user_tab_privs_recd (table level) and user_col_privs_recd (column level). The table owner (or a DBA) has to grant the missing privilege.

Causes and fixes

  1. Only SELECT was granted, then you UPDATE
  2. UPDATE was granted only on some columns
  3. MERGE with only INSERT privilege
  4. READ privilege with SELECT ... FOR UPDATE

1Only SELECT was granted, then you UPDATE

lab_a could read lab_b.price (items 1 and 2), but UPDATE lab_b.price SET price = 120 failed with missing UPDATE privilege on "LAB_B"."PRICE". user_tab_privs_recd showed just one row: PRICE SELECT.

The owner ran GRANT UPDATE ON price TO lab_a. The same UPDATE then returned 1 row updated and item 1 became 120.

Setup
Setuprun as lab_b
CREATE TABLE price (item_id NUMBER PRIMARY KEY, price NUMBER);
INSERT INTO price VALUES (1, 100);
INSERT INTO price VALUES (2, 250);
COMMIT;
GRANT SELECT ON price TO lab_a;
OUTPUT
Table created.


1 row created.


1 row created.


Commit complete.


Grant succeeded.
Reproducerun as lab_a
SELECT item_id, price FROM lab_b.price ORDER BY item_id;
UPDATE lab_b.price SET price = 120 WHERE item_id = 1;
OUTPUT
   ITEM_ID      PRICE
---------- ----------
         1        100
         2        250

2 rows selected.

UPDATE lab_b.price SET price = 120 WHERE item_id = 1
             *
ERROR at line 1:
ORA-41900: missing UPDATE privilege on "LAB_B"."PRICE"
Help: https://docs.oracle.com/error-help/db/ora-41900/
Checkrun as lab_a
COLUMN owner FORMAT A8
COLUMN table_name FORMAT A10
COLUMN privilege FORMAT A10
SELECT owner, table_name, privilege FROM user_tab_privs_recd ORDER BY table_name, privilege;
OUTPUT
OWNER    TABLE_NAME PRIVILEGE
-------- ---------- ----------
LAB_B    PRICE      SELECT

1 row selected.
Fixrun as lab_b
GRANT UPDATE ON price TO lab_a;
OUTPUT
Grant succeeded.
After the fixrun as lab_a
UPDATE lab_b.price SET price = 120 WHERE item_id = 1;
COMMIT;
SELECT item_id, price FROM lab_b.price ORDER BY item_id;
OUTPUT
1 row updated.


Commit complete.


   ITEM_ID      PRICE
---------- ----------
         1        120
         2        250

2 rows selected.

2UPDATE was granted only on some columns

The grant was GRANT SELECT, UPDATE (price) ON item TO lab_a. UPDATE lab_b.item SET price = 110, cost = 75 failed, because cost is not covered. The message only names the table, so it looks like there is no UPDATE privilege at all.

user_col_privs_recd showed ITEM PRICE UPDATE (one column only). After GRANT UPDATE (cost) ON item TO lab_a, the UPDATE succeeded with price 110 and cost 75.

Setup
Setuprun as lab_b
CREATE TABLE item (item_id NUMBER PRIMARY KEY, price NUMBER, cost NUMBER);
INSERT INTO item VALUES (1, 100, 70);
COMMIT;
GRANT SELECT, UPDATE (price) ON item TO lab_a;
OUTPUT
Table created.


1 row created.


Commit complete.


Grant succeeded.
Reproducerun as lab_a
UPDATE lab_b.item SET price = 110, cost = 75 WHERE item_id = 1;
OUTPUT
UPDATE lab_b.item SET price = 110, cost = 75 WHERE item_id = 1
             *
ERROR at line 1:
ORA-41900: missing UPDATE privilege on "LAB_B"."ITEM"
Help: https://docs.oracle.com/error-help/db/ora-41900/
Checkrun as lab_a
COLUMN owner FORMAT A8
COLUMN table_name FORMAT A10
COLUMN column_name FORMAT A12
COLUMN privilege FORMAT A10
SELECT owner, table_name, column_name, privilege FROM user_col_privs_recd;
OUTPUT
OWNER    TABLE_NAME COLUMN_NAME  PRIVILEGE
-------- ---------- ------------ ----------
LAB_B    ITEM       PRICE        UPDATE

1 row selected.
Fixrun as lab_b
GRANT UPDATE (cost) ON item TO lab_a;
OUTPUT
Grant succeeded.

If user_tab_privs_recd shows no UPDATE but the owner says it was granted, check user_col_privs_recd.

After the fixrun as lab_a
UPDATE lab_b.item SET price = 110, cost = 75 WHERE item_id = 1;
COMMIT;
SELECT item_id, price, cost FROM lab_b.item;
OUTPUT
1 row updated.


Commit complete.


   ITEM_ID      PRICE       COST
---------- ---------- ----------
         1        110         75

1 row selected.

3MERGE with only INSERT privilege

An interface account had SELECT, INSERT on lab_b.stock. A MERGE that updates existing items and inserts new ones failed with missing UPDATE privilege on "LAB_B"."STOCK". A MERGE with a WHEN MATCHED THEN UPDATE clause needs UPDATE as well as INSERT.

After GRANT UPDATE ON stock TO lab_a, it printed 2 rows merged: item 1 went from 10 to 15, and item 2 (qty 7) was inserted.

Setup
Setuprun as lab_b
CREATE TABLE stock (item_id NUMBER PRIMARY KEY, qty NUMBER);
INSERT INTO stock VALUES (1, 10);
COMMIT;
GRANT SELECT, INSERT ON stock TO lab_a;
OUTPUT
Table created.


1 row created.


Commit complete.


Grant succeeded.
Setuprun as lab_a
CREATE TABLE stock_in (item_id NUMBER, qty NUMBER);
INSERT INTO stock_in VALUES (1, 5);
INSERT INTO stock_in VALUES (2, 7);
COMMIT;
OUTPUT
Table created.


1 row created.


1 row created.


Commit complete.
Reproducerun as lab_a
MERGE INTO lab_b.stock s
USING stock_in i ON (s.item_id = i.item_id)
WHEN MATCHED THEN UPDATE SET s.qty = s.qty + i.qty
WHEN NOT MATCHED THEN INSERT (item_id, qty) VALUES (i.item_id, i.qty);
OUTPUT
MERGE INTO lab_b.stock s
                 *
ERROR at line 1:
ORA-41900: missing UPDATE privilege on "LAB_B"."STOCK"
Help: https://docs.oracle.com/error-help/db/ora-41900/
Fixrun as lab_b
GRANT UPDATE ON stock TO lab_a;
OUTPUT
Grant succeeded.
After the fixrun as lab_a
MERGE INTO lab_b.stock s
USING stock_in i ON (s.item_id = i.item_id)
WHEN MATCHED THEN UPDATE SET s.qty = s.qty + i.qty
WHEN NOT MATCHED THEN INSERT (item_id, qty) VALUES (i.item_id, i.qty);
COMMIT;
SELECT item_id, qty FROM lab_b.stock ORDER BY item_id;
OUTPUT
2 rows merged.


Commit complete.


   ITEM_ID        QTY
---------- ----------
         1         15
         2          7

2 rows selected.

4READ privilege with SELECT ... FOR UPDATE

The account had GRANT READ ON emp. A plain SELECT worked, but SELECT ... FOR UPDATE failed with missing SELECT privilege on "LAB_B"."EMP". READ allows queries but not locking rows.

After GRANT SELECT ON emp TO lab_a, the FOR UPDATE query returned the row.

Setup
Setuprun as lab_b
CREATE TABLE emp (emp_id NUMBER PRIMARY KEY, name VARCHAR2(20), salary NUMBER);
INSERT INTO emp VALUES (1, 'KIM', 300);
COMMIT;
GRANT READ ON emp TO lab_a;
OUTPUT
Table created.


1 row created.


Commit complete.


Grant succeeded.
Reproducerun as lab_a
SELECT emp_id, name FROM lab_b.emp WHERE emp_id = 1;
SELECT emp_id, name FROM lab_b.emp WHERE emp_id = 1 FOR UPDATE;
OUTPUT
    EMP_ID NAME
---------- ------------------------------
         1 KIM

1 row selected.

SELECT emp_id, name FROM lab_b.emp WHERE emp_id = 1 FOR UPDATE
                               *
ERROR at line 1:
ORA-41900: missing SELECT privilege on "LAB_B"."EMP"
Help: https://docs.oracle.com/error-help/db/ora-41900/
Fixrun as lab_b
GRANT SELECT ON emp TO lab_a;
OUTPUT
Grant succeeded.

Read-only accounts are often given READ on purpose. Check whether the account really needs to lock rows before switching to SELECT.

After the fixrun as lab_a
SELECT emp_id, name FROM lab_b.emp WHERE emp_id = 1 FOR UPDATE;
ROLLBACK;
OUTPUT
    EMP_ID NAME
---------- ------------------------------
         1 KIM

1 row selected.


Rollback complete.

FAQ

What is ORA-41900 in Oracle 23ai?

An error for a missing object privilege such as UPDATE, INSERT, DELETE or SELECT on a specific table. Before 23ai the same case raised ORA-01031: insufficient privileges.

How do I check which table privileges I have?

SELECT owner, table_name, privilege FROM user_tab_privs_recd for table-level grants and user_col_privs_recd for column-level grants.

Why does MERGE fail with ORA-41900 when I have INSERT?

A MERGE with WHEN MATCHED THEN UPDATE also needs UPDATE on the target table.

Why does SELECT FOR UPDATE give ORA-41900 when SELECT works?

You probably have READ, not SELECT. READ does not allow FOR UPDATE. In this lab GRANT SELECT fixed it.

How we verify

Each scenario starts from fresh database users. A script runs the setup, confirms the exact error code, applies the fix and runs the statement again. The output shown is what the database printed, saved by the script.

lab_a and lab_b are ordinary users created for the test; system is the DBA account. Oracle AI Database 26ai Free Release 23.26.3.0.0 - Develop, Learn, and Run for Free

Related errors