Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
When a user tries to create a materialized view in a different schema, if the user of that schema does not have create table authority, …
Read More »
Tag Archives: ORA-01031
READ Object Privilege in Oracle 12c
The READ object privilege introduced with the 12c (12.1.0.2) version. It allows us to read a table without locking. It is used to create read-only …
Read More »Data Pump, expdp ORA-39127, ORA-01031, ORA-06512 Errors
When you are backing up with Data Pump (expdp), it may indicate that the privileges are insufficient and may end with errors such as ORA-39127, …
Read More »