How to Grant privileges of another user in Oracle

Rumesh Aponso (RMAX)

Nov 13, 20241 min read

ALTER USER DUMMYUSER ACCOUNT UNLOCK;

ALTER USER DUMMYUSER IDENTIFIED BY PASSWORD;

ALTER USER MAINUSER GRANT CONNECT THROUGH DUMMYUSER;

Access Username: DUMMYUSER [MAINUSER]

Example 1: SELECT handling_unit_id, t.shipment_id FROM handling_unit_tab t START WITH handling_unit_id = '4558' CONNECT BY PRIOR...

Decode base64 in PLSQL: DECLARE CURSOR get_base64_clob IS SELECT neutral_file FROM c_smart_document_tab WHERE sequence_no = '42'; ...

Related Posts