• Home
  • About
  • Log In
  • Register
  • Job Openings
Follow Us
KTEXPERTS
  • Oracle DBA
    • Oracle 12C New Features
      • Oracle Multitenant Features
      • Non Container Features
    • Oracle Architecture
      • Oracle Server Architecture
      • Oracle Background Processes
      • Oracle Pyhisical Database
      • Select and Update Statement
      • Startup and Shutdown Modes
      • Redolog File Management
      • User Management
        • RMAN (Recovery Manager)
        • Oracle Production Support Scripts
    • Oracle Tablespace Management
    • Oracle Datapump (Exports & Imports)
    • Performance Tuning
    • Oracle Dataguard
    • Oracle ASM
    • Oracle Auditing
    • Oracle Partitioning
    • SecureCRT
    • Partitions/Shell Script
  • Oracle RAC
    • Introduction to Oracle RAC
    • 11gR2 RAC Installation
    • 12cR2 RAC Installation
    • 19c RAC Installation
    • Flashback Restore on Two Node RAC Servers
  • GoldenGate
    • Oracle to Oracle GoldenGate Unidirectional Replication
    • MySQL to Oracle Heterogeneous Replication
    • Oracle to MySQL Heterogeneous Replication
    • CredentialStore in Goldengate
    • GoldenGate Monitoring Commands
    • Usage of HandleCollisions and No HandleCollisions
    • Goldengate subdirs
    • Enable/Disable DDL replication
    • Data Selection & Filtering
    • Automation scripts in Goldengate
    • Logdump utility
    • Initial loads with GoldenGate
    • IgnoreDelete and IgnoreUpdate parameters in GG
    • COLS & COLSEXCEPT FILTER in GG
    • Add new table to existing GoldenGate Replication
      • Cassandra
  • AWS
    • EC2 (Elastic Compute Cloud)
    • S3 (Simple Storage Service)
    • IAM (Identity and Access Management)
    • CloudWatch
    • VPC (Virtual Private Cloud)
    • Route 53
    • RDS
    • Dynamo DB
    • EFS (Elastic File System)
    • Cloud Trail
    • Cloud Front
    • SNS (Simple Notification Service)
    • SQS (Simple Queue Service)
    • SES (Simple Email Service)
    • Redshift
    • Elastic Cache
    • Snowball
  • SQL Server
  • DevOps
    • LINUX
    • GIT
    • Chef
    • Ansible
    • Docker
    • Maven
  • MySQL
    • MySQL Installation & Upgrade
    • MySQL DBA
    • Difference Between Oracle and MySQL
  • PostgreSQL
    • Installation of PostgreSQL
    • WAL Internals in PostgreSQL
    • Replication to GCP PostgreSQL
    • Level of Work in Postgres Database
    • Data Fragmentation in PostgreSQL
    • PostgreSQL Interview Q&A
    • PostgreSQL Commands
  • Authors
    • Authors
    • Speakers
    • Volunteers
  • INDEX
    • Oracle DBA
      • Performance Tuning
      • Oracle RAC
      • Oracle 12c New Features
      • Oracle Production Support Scripts
      • Oracle DataGuard
      • Data Pump (Export & Import)
      • Oracle 18c
      • RMAN (Recovery Manager)
      • Oracle Tablespaces
      • Oracle ASM
      • Oracle Partitioning
      • Oracle Architecture
    • PostgreSQL
    • AWS
    • DevOps
    • GoldenGate
    • Cassandra
    • SQL Server
    • Oracle RAC
    • MySQL
    • SecureCRT
  • Webinar Recordings
  • Daily Tips
    • Oracle DBA Tips
    • GoldenGate Tips
    • MySQL Tips
    • SQL Server Tips
    • PostgreSQL Tips
    • MongoDB Tips
    • DevOps Tips
    • Exadata Tips
    • Python Tips
    • Data Science Tips
    • AWS Tips
    • .NET Tips
    • Linux Tips
  • Python
  • MongoDB
mm

Adityanath Dewoolkar

I’m an Oracle DBA based in Mumbai, India with several years of experience managing UNIX plus Windows – based Oracle Databases from 8i to 19c. Currently I’m leading Oracle DBA Team, supporting various Oracle products in one of the leading banking group in South Africa. www.linkedin.com/in/adityanath-dewoolkar-07253123/

Follow

Share this post

Tags

  • CREATE USER NO AUTHENTICATION
  • NO AUTHENTICATION;
  • oracle 18c new feature
  • oracle Schema Only Account
  • Schema Only Account

Oracle 18C new feature: Schema Only Account

Posted on January 29, 2020 in Oracle 18c, Oracle DB Admin
Share via:
Post Views: 3,525

This article focuses on Oracle 18C new feature: Schema Only Account. This allows schemas can be created without a password from Oracle Database 18C.

BACKGROUND:

Schema is a collection of objects, while DB user is an account to connect to instance. Till Oracle 12C, Oracle always allowed to connect to instance using schemas as well as DB users.

It’s always a bad idea to configure your applications schema credentials as this allows application to have far more privileges than required & it’s a big security risk as using schema credentials one can do almost all changes in objects under ownership of schema.

Instead, it is recommended to configure application users and grant them the necessary privileges on the schema owners objects. 

So, one need to restrict direct access to a schema, preventing people accessing it using shared credentials. Instead one access it to do schema changes via a proxy connection, allowing you to audit which users performed which tasks.

ABOUT NEW FEATURE:

From 18C, Oracle now allows to create schemas without password so it cannot to be used to connect to instance & could connect using proxy user. This can allow DBA’s to further secure their databases & applications.

You can grant any system privileges and roles to schema only accounts. Schema only accounts can do all operations as per privileges assigned to them.

USAGE:

Create a Schema Only Account:

CREATE USER <USERNAME> NO AUTHENTICATION;

Alter existing user to Schema Only Account:

ALTER USER <USERNAME> NO AUTHENTICATION;

Find current “Schema Only Accounts” in database:

SELECT USERNAME FROM DBA_USERS WHERE AUTHENTICATION_TYPE='NONE';

Switch a Schema Only Account to normal schema:

ALTER USER <USERNAME> IDENTIFIED BY <PASSWORD>;

How to connect to Schema Only Account using proxy users:

CREATE USER <PROXYUSER> identified by <PROXYPASSWORD>;

ALTER USER <USERNAME> GRANT CONNECT THROUGH <PROXYUSER>;

CONN <PROXYUSER>[<USERNAME>]/<PROXYPASSWORD>@<CONNECTION_STRING>

 


Stay tuned for More articles on Oracle 18c.

Hope u will find this post very useful.  🙂

Cheers!!!

Regards,

Adityanath

Email ID: adityanath.dewoolkar@gmail.com

LinkedIn: www.linkedin.com/in/adityanath-dewoolkar-07253123/

Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

You might also like...

  • Table/index movement using pl/sql procedure

    Table/index movement using pl/sql procedure

  • Datapump export and import from Source PDB to Target PDB

    Datapump export and import from Source PDB to Target PDB

  • Pluggable database save state

    Pluggable database save state

Previous Post: Most Useful Docker Commands
Next Post: Oracle 18C new feature: Cancel SQL instead of killing session

Add Comment Cancel reply

Visa Sponsorship

Recent Comments

  • Binnary Ajay Kumar on How to move or rename Oracle Home
  • Prabhu on How to move or rename Oracle Home
  • Krishna on Protected: How to kill Long Running Query using scripts.
  • krishna on Linux Basic Commands for DevOps (PART-2)
  • Ankit on Data Fragmentation in PostgreSQL

Started ktexperts.com with a small hope of sharing knowledge, And today we can proudly say that ktexperts.com is being accessed from all corners of the world. Here’s a glimpse of our growth.

Categories

Ad

KT Experts Journey….! Watch and Subscribe Our KT Experts YouTube Channel.

https://www.youtube.com/watch?v=kzqFBMFlzRI

Recent Posts

  • Protected: OPERATORS IN PYTHON March 15, 2023
  • Protected: Installation of PostgreSQL March 15, 2023
  • Protected: Introduction to MongoDB March 11, 2023
  • Introduction to PostgreSQL March 6, 2023
  • FUNCTIONS IN PYTHON February 28, 2023
  • Table/index movement using pl/sql procedure February 23, 2023
  • Protected: Share Knowledge February 21, 2023

About KTEXPERTS

KT Experts is one enthusiastic knowledge-sharing platform. The platform concentrates on all Database Technologies like Oracle Database Administration(DBA), Oracle RAC, Oracle GoldenGate, MySQL, SQL Server Database Administration, Cassandra, AWS and DevOps.

This page consists of all the well-developed articles  of the Technologies. This is an effort of many dedicated professionals for a better IT world.

We have received the best reviews over time and the usage of this page has been increasingly drastic. So why wait? Let’s get started!!!

Thank you 

Follow Our Social Networking Sites

Recent Posts

  • Protected: OPERATORS IN PYTHON

  • Protected: Installation of PostgreSQL

  • Protected: Introduction to MongoDB

    Protected: Introduction to MongoDB

  • Introduction to PostgreSQL

    Introduction to PostgreSQL

  • FUNCTIONS IN PYTHON

    FUNCTIONS IN PYTHON

Our Partners

Scholar IT Solutions

Website Visitors


Locations of visitors to this page

COPYRIGHT © 2017 - KTEXPERTS.COM Back To Top
sponsored