Oracle database read only user

Creating a read only user in Oracle Database There are many ways of achieving a read only user, here is a simple method using synonyms that creates a script to give RO_USER access to the RW_USER tables and views: –As a dba user, create the read only user CREATE USER RO_USER identified by password; GRANT…

Read More...

Using Oracle Database LoadJava

LoadJava Oracle provides the LoadJava tool to create schema objects from Java source, class, data files or SQLJ files. The LoadJava tool is located in the bin directory under $ORACLE_HOME. CREATE PROCEDURE and CREATE TABLE privileges are required to load into your schema. CREATE ANY PROCEDURE and CREATE ANY TABLE privileges are required to load into…

Read More...

Oracle 19c database on LiveSQL

Oracle database 19c Oracle database 19c is currently available at LiveSQL.oracle.com and on premise Exadata. LiveSQL is a free online platform that can assist with development and training. Other on premise releases are expected in the next few months of Q2CY19. 19c is the long term support release of 12cR2 with extended support until Mar 2026….

Read More...

Oracle Database 12c, 18c and 19c product versions and should I upgrade

As many would know in the Oracle circles, there has been a ‘new’ database version available this year. Don’t get me wrong, 18c is a new version but not a major release but a new approach to the software releases. 18c is equivalent to 12.2.0.2 and 19c will be the terminal release 12.2.0.3. As with…

Read More...

Discover Your Opportunities

Data Solutions | Application Development | Automation

GET STARTED TODAY