• Home
  • About
  • Log In
  • Register
  • Upcoming Sessions
Follow Us
KTEXPERTS
  • Oracle DBA
    • Oracle 12C New 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
    • Oracle Tablespace Management
    • Oracle Datapump (Exports & Imports)
    • Performance Tuning
      • Wait Events
    • RMAN (Recovery Manager)
    • Oracle Dataguard
    • Oracle ASM
    • Oracle Production Support Scripts
    • Oracle Auditing
    • Oracle Partitioning
    • SecureCRT
    • Partitions/Shell Script
  • Oracle RAC
    • Introduction to Oracle RAC
    • 12cR2 RAC Installation
    • Flashback Restore on Two Node RAC Servers
  • GoldenGate
    • MySQL to Oracle Heterogeneous Replication
    • Oracle to MySQL Heterogeneous Replication
    • 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
  • Authors
    • Authors
    • Speakers
    • Volunteers
  • INDEX
    • Oracle DBA
    • AWS
    • DevOps
    • GoldenGate
    • Cassandra
    • SQL Server
    • Oracle RAC
    • MySQL
    • SecureCRT
  • Daily Tips
    • Oracle DBA Tips
    • GoldenGate Tips
    • MySQL Tips
    • SQL Server Tips
    • PostgreSQL Tips
    • MongoDB Tips
    • AWS Tips
    • DevOps Tips
    • Exadata Tips
    • Python Tips
    • Data Science Tips
    • .NET Tips
    • Linux Tips
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 DB Admin, User Management
Share via:
Post Views: 1,912

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...

  • Important Oracle v$parameters (SecureCRT)

    Important Oracle v$parameters (SecureCRT)

  • How to Switch/Recreate Undo Tablespace at PDB Level(12cR2)

    How to Switch/Recreate Undo Tablespace at PDB Level(12cR2)

  • Manage SQL Profile in Oracle Database

    Manage SQL Profile in Oracle Database

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

Add Comment Cancel reply

Achievements

Our Rank is #42
Our Rank is #37

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

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

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.

Follow Our Social Networking Sites

Categories

Recent Comments

  • CBD oil for sale on Oracle_Apps: How To Kill runaway processes After Terminating Concurrent Request
  • CBD oil for sale on Oracle_Apps: How To Kill runaway processes After Terminating Concurrent Request
  • Atul Chandge on Oracle (SecureCRT) : Temp Tablespace Monitoring Queries
  • santhi on How to download and Install Chef in Amazon EC2 Linux Instance
  • Nayab on How to download and Install Chef in Amazon EC2 Linux Instance

Recent Posts

  • Installation of AWS CLI and S3FS April 19, 2021
  • Important Oracle v$parameters (SecureCRT) April 19, 2021
  • How to Switch/Recreate Undo Tablespace at PDB Level(12cR2) April 12, 2021
  • Manage SQL Profile in Oracle Database April 6, 2021
  • Resource Manager in Oracle March 30, 2021
  • Oracle Sample Unix script to monitor select query during Load Test March 25, 2021
  • Configure Active DataGuard and DG BROKER March 24, 2021

Ratings

  • Oracle : Oracle Server Architecture 30 votes, average: 5.00 out of 530 votes, average: 5.00 out of 530 votes, average: 5.00 out of 530 votes, average: 5.00 out of 530 votes, average: 5.00 out of 5 (5.00 out of 5)
  • Invisible columns in Oracle 12c 28 votes, average: 5.00 out of 528 votes, average: 5.00 out of 528 votes, average: 5.00 out of 528 votes, average: 5.00 out of 528 votes, average: 5.00 out of 5 (5.00 out of 5)
  • Oracle_Apps: How To Kill runaway processes After Terminating Concurrent Request 27 votes, average: 5.00 out of 527 votes, average: 5.00 out of 527 votes, average: 5.00 out of 527 votes, average: 5.00 out of 527 votes, average: 5.00 out of 5 (5.00 out of 5)
  • TOP N QUERIES in Oracle 12c 27 votes, average: 5.00 out of 527 votes, average: 5.00 out of 527 votes, average: 5.00 out of 527 votes, average: 5.00 out of 527 votes, average: 5.00 out of 5 (5.00 out of 5)
  • Hadoop : What is BIG DATA? 27 votes, average: 5.00 out of 527 votes, average: 5.00 out of 527 votes, average: 5.00 out of 527 votes, average: 5.00 out of 527 votes, average: 5.00 out of 5 (5.00 out of 5)
  • Hadoop : BACKUP AND RESTORE PROCEDURES IN HADOOP 26 votes, average: 5.00 out of 526 votes, average: 5.00 out of 526 votes, average: 5.00 out of 526 votes, average: 5.00 out of 526 votes, average: 5.00 out of 5 (5.00 out of 5)
  • 12CR2 SQL*PLUS History Command 26 votes, average: 5.00 out of 526 votes, average: 5.00 out of 526 votes, average: 5.00 out of 526 votes, average: 5.00 out of 526 votes, average: 5.00 out of 5 (5.00 out of 5)
  • Data Masking in Oracle 12c 26 votes, average: 5.00 out of 526 votes, average: 5.00 out of 526 votes, average: 5.00 out of 526 votes, average: 5.00 out of 526 votes, average: 5.00 out of 5 (5.00 out of 5)
  • MySQL : About MySQL 25 votes, average: 5.00 out of 525 votes, average: 5.00 out of 525 votes, average: 5.00 out of 525 votes, average: 5.00 out of 525 votes, average: 5.00 out of 5 (5.00 out of 5)
  • Oracle : REDOLOG FILE MANAGEMENT 25 votes, average: 5.00 out of 525 votes, average: 5.00 out of 525 votes, average: 5.00 out of 525 votes, average: 5.00 out of 525 votes, average: 5.00 out of 5 (5.00 out of 5)

Ad

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

  • Installation of  AWS CLI and S3FS

    Installation of AWS CLI and S3FS

  • Important Oracle v$parameters (SecureCRT)

    Important Oracle v$parameters (SecureCRT)

  • How to Switch/Recreate Undo Tablespace at PDB Level(12cR2)

    How to Switch/Recreate Undo Tablespace at PDB Level(12cR2)

  • Manage SQL Profile in Oracle Database

    Manage SQL Profile in Oracle Database

  • Resource Manager in Oracle

    Resource Manager in Oracle

Our Partners

Our Partners

Northern California Oracle Users Group

Scholar IT Solutions

Website Visitors


Locations of visitors to this page

COPYRIGHT © 2017 - KTEXPERTS.COM Back To Top
sponsored