create external user

How to Create an External user using Create user statement

Create external user using create user command in SQL

To create external user and his authentication are managed by external services like as network service or operating system services. The user who is authenticate by the OS (operating system) can access the Database without any password.

The external users are classic default and regular database users (non-dba) who are assigned standard database roles (such as CONNECT and RESOURCE). But no SYSOPER (database operator) or SYSDBA (database administrator) privilege.

Before creating an external user you must check the Oracle OS_AUTHENT_PREFIX initialization parameter, using following command.

SQL> SHOW PARAMETER os_authent_prefix

NAME                         TYPE        VALUE
-----------------------    ----------- ------------------------------
os_authent_prefix           string      ops$

You can see the value of os_authent_prefix parameter default value is “ops$”, if it’s not same like that in your case, then you can change it using ALTER COMMAND.

Now create an external user using following command.

SQL>Create user “ops$oracle” Identified by externally;

Your user has been created successfully, Now we have need to grant mandatory system privilege which is “Create Session” so that it can be log on to database.

SQL> GRANT create session TO “ops$oracle”;

Now external user can be login in database without using username or password, it’s just use the forward slash (/).

$sqlplus /
SQL>show user

You also read Oracle ALTER TABLE MODIFY

You Can subscribe my YouTube channel

Share this
Share

3 thoughts on “How to Create an External user using Create user statement”

  1. Hi, Shreepal,

    Your HOW TO INSTALL ORACLE GRID AND RDBMS TOGATHER SCRIPT IS HALF WRITTEN, PLEASE COMPLETE ALL THE STEPS
    OF INSTALLATION AND ALSO GIVE SCRIPT AND VIDEO OF CREATION OF NEW NODE IN RAC

    THANKS

Leave a Comment

Share