EXTERNAL USER CREATION
External users and their authentication are managed by external services such as operating system or a network service.
If our OS environment is secured, we can enable remote access by setting REMOTE_OS_AUTHENT=TRUE, which means that Oracle will authenticate remote connections using the OS_AUTHENT_PREFIX.
This will allow remote users to connect to the Oracle database without supplying a password.
Set the Remote_os_authent=true
alter system set remote_os_authent=TRUE scope=SPFILE;
OS_AUTHENT_PREFIX parameter is responsible for telling the oracle that the user which we are going to create is an external user and not any other type of user.The default value of OS_AUTHENT_PREFIX is OPS$
alter system set os_authent_prefix=’ ‘ scope=SPFILE; –If you don’t need OPS$ prefix in username please do this
To create an external user we will use the Create User statement.
CERATE USER “OPS$LOCALHOST\SATHISH” IDENTIFIED externally;
we have to give the system privilege ‘Create Session’ so that we can log on to database using this user.
GRANT create session TO “OPS$LOCALHOST\SATHISH”;
Now all the authentications are handled by operating system. Thus log on to our database using this user by using the command
C:\> sqlplus /
