Oracle Database 19c Related Various SQL Codes, Database 19c , SQL Codes, jaberitltd, jaberit, oracle apex, racle Drop User, insufficient privilege
How To Solve Ora-01031: Insufficient Privilege
How To Solve Ora-01031 Insufficient Privilege How To Solve Ora-01031 Insufficient Privilege How To Solve Ora-01031: Insufficient Privilege Create Objects And Facilities It Is Unusual, But Possible, To Give A Schema A Privilege Like Delete Without Granting Select. Grant Privileges For Schema. GRANT ALL PRIVILEGES TO test; By Default - Other Users Have The Privilege To Change. How Do I Know? SELECT *
FROM dba_sys_privs
WHERE grantee = 'DBA'
ORDER BY privilege; Solve Ora-01031: Insufficient Privilege 1. Create Table CREATE USER test
IDENTIFIED BY test123;
GRANT CREATE SESSION TO test;
GRANT CREATE TABLE TO test; 2. Insert, Update and Delete GRANT INSERT, UPDATE, DELETE ON test.t1 TO test; 3. Change Table (Add Consistency) GRANT REFERENCES ON hr.employees TO test; 4. Create Index GRANT INDEX ON sh.customers TO test;
CREATE INDEX customer_id_gen_idx
ON sh.t1 (t_id, t_gender); 5. Create View GRANT SELECT ON sh.sales TO test; 6. Allowing the user directly GRANT CREATE ANY DIRECTORY…
