Make Custom User Authorization Schemes. Oracle Apex. Part-1

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, DROP ANY DIRECTORY TO test;

7. Use Invoker's Right 

REVOKE CREATE ANY DIRECTORY, DROP ANY DIRECTORY FROM test;

8. Anonymous PL/SQL Block 

BEGIN
    EXECUTE IMMEDIATE 'drop directory test_path';

    EXECUTE IMMEDIATE 'create or replace directory test_path as ''/u02/tmp''';
END;

DBA_TABLES and USER_TABLES in PL SQL cursor

The User Must Have Select Privileges In That View. To Check If The User Has Select Permission Against This View, Log In As This User And Run The Following Query:

SELECT *
  FROM user_tab_privs
 WHERE table_name = 'DBA_TABLES';

SELECT *
  FROM user_tab_privs
 WHERE table_name = 'DBA_TABLES';

To grant that user this privilege, login as SYS or SYSTEM and issue: 

GRANT SELECT ON DBA_TABLES TO test;

The user will then see a result like the following, and will have access to that view: 

SELECT table_name, privilege
  FROM user_tab_privs
 WHERE table_name = 'DBA_TABLES';

Check the tablespace's configuration. 

SELECT TABLESPACE_NAME, CONTENTS, BIGFILE FROM DBA_TABLESPACES;

Check that the AutoExtend feature is turned on, the current size of the datafile, and the maximum configured range: 

SELECT TABLESPACE_NAME,
         ROUND (SUM (BYTES) / (1024 * 1024 * 1024), 2)     SUM_GB,
         ROUND (MAXBYTES / (1024 * 1024 * 1024), 2)        MAX_GB,
         AUTOEXTENSIBLE
    FROM DBA_DATA_FILES
GROUP BY TABLESPACE_NAME, MAXBYTES, AUTOEXTENSIBLE;

For temporary table spaces: 

SELECT TABLESPACE_NAME,
         ROUND (SUM (BYTES) / (1024 * 1024 * 1024), 2)     SUM_GB,
         ROUND (MAXBYTES / (1024 * 1024 * 1024), 2)        MAX_GB,
         AUTOEXTENSIBLE
    FROM DBA_TEMP_FILES
GROUP BY TABLESPACE_NAME, MAXBYTES, AUTOEXTENSIBLE;

 

🔗 Demo Application-
            URL- Demo Application
            Username - demo, Pass- demo
 

I hope everyone will like it. Please watch the full video,
Comment on any of your problems, I will try my best to solve the problem, In-Shah Allah. Everyone's cooperation is desirable. Visit my blog site, new technology related videos, you will get different types of tutorials of Oracle Apex, and hopefully, you can use them in your daily work.
Please stay tuned by subscribing to the YouTube channel, and encourages new videos to be uploaded.
=================
Visit my site to get more collaborative posts about Oracle Apex and subscribe to my YouTube channel. Thanks.
Comment on any of your issues, I will try my best to solve the problem, In-Shah Allah. Everyone's cooperation is desirable.
Visit my blog site, new technology-related videos, you will get different types of tutorials of Oracle Apex, and hopefully, you can use them in your daily work.
==============================

🙍🏾‍ Md jABER HOSSEN
📲 Mobile- +8801760688286
📨 Email- jaberit786@gmail.com
🌐 FB- facebook.com/mdjaber.hossen1
Please Subscribe to My Channel

Many thanks for visiting the site.

Then Enjoy.........................

 

🔗 Demo Application-
            URL- Demo Application
            Username - demo, Pass- demo
 

I hope everyone will like it. Please watch the full video,
Comment on any of your problems, I will try my best to solve the problem, In-Shah Allah. Everyone's cooperation is desirable. Visit my blog site, new technology related videos, you will get different types of tutorials of Oracle Apex, and hopefully, you can use them in your daily work.
Please stay tuned by subscribing to the YouTube channel, and encourages new videos to be uploaded.
=================
Visit my site to get more collaborative posts about Oracle Apex and subscribe to my YouTube channel. Thanks.
Comment on any of your issues, I will try my best to solve the problem, In-Shah Allah. Everyone's cooperation is desirable.
Visit my blog site, new technology-related videos, you will get different types of tutorials of Oracle Apex, and hopefully, you can use them in your daily work.
==============================

🙍🏾‍ Md jABER HOSSEN
📲 Mobile- +8801760688286
📨 Email- jaberit786@gmail.com
🌐 FB- facebook.com/mdjaber.hossen1
Please Subscribe to My Channel

Many thanks for visiting the site.

Then Enjoy.........................