SQL tutorial 43: How to create an EXTERNAL USER in oracle database By Manish Sharma RebellionRider

Key Takeaways

what's up internet I'm Manish from Rebellion rider.com and today in this SQL tutorial we will learn how to create an external user I have already done a series of videos where I showed you the different ways of creating a local user in Oracle database the authentication of local user is handled by Oracle data dictionaries using password but the authentication of external user is managed by external services such as your operating system the user who is authenticated by the operating system can easily access the database without being requested for a password so without further Ado let's start today's tutorial before starting the tutorial I just want to tell you that using these step you can create external user in any Windows Linux as well as on Mac environment steps are the same so the name of external user is a string which is a combination of three factors these three factors are host name which is your computer's name you can very easily find the host name of your machine by simply writing host name in your command prompt and hitting enter this will show you the host name of your machine note here that a host name is only required when you are creating an external user on Windows machine but if you're are using an a Unix or a Linux machine then there is no need of a host name so you can skip this step if you are on a Linux machine as we can see here my host name is m- thing second factor is the user account name of your operating system this is the name of your user account for which you want to create an external user mind here that the authentication information of this account such as password will be served as authentication information of your external user to find the username of your OS simply write and hit enter my username is M and the third Factor here is OS authent prefix which is a special Oracle parameter this parameter is responsible for telling the Oracle that the user which we are going to create is an external user and not a local one or for that matter any other type of user the name of all the external user must start with the value of this parameter to get the value of this parameter first you need to log onto your database using CIS user with CIS DB your privileges let me show you the user once as you can see our user assist now write and here in the fourth line you can see the value of os authent prefix parameter which is Ops dollar okay now we have the values for all the three parameters now let's create the name of our external user while creating the name of the external user you have to keep keep certain things in mind such as name of external user must always start with the value of os authent prefix parameter followed by the host name and then a backward slash after which comes your user account name in case you are using Unix or Linux machine then we will skip the host name from the name of our external user since now we know the name of our external user hence creating it is a piece of cake to create an external user we will again use the create user statement let's see how let me clear this screen screen first so that you people can see what I'm going to do next okay now let's create our external user above query is fairly simple create and user both are the keywords followed by the name of our user which we just determined and then identified clause which is followed by externally keyword always remember to enclose the name String in double quotes as we have dollar sign in this string and this name String should be in all caps I highly suggest you to watch my videos on how to create user for the better understanding of this concept link is in the description box okay now let's hit enter user created as our external user has been created now we have to Grant this user a special as well as mandatory system privilege which is create session so that we can log onto our database using this user grants succeeded now as it's an external user this means that all its authentications are handled by operating system thus to log onto our database using this user we have to Simply write okay first let's exit from this SQL front let me clear the screen okay now let's try to log onto our database using our external user which we just created to log on to our database using an external user we just have to write yes no need to supply user name or any password so let's quickly check the user as you can see this is the name of the user which we just created this is an external user that's it that's how we create an external user that's it for today's guys hope you enjoyed watching if you want me to do more such quick and crispy video then please hit the like button and comment below and tell me how you like my videos also do subscribe to my channel and be the first one to watch my videos I read all your comments and tweet so you can follow me on my social network all the links are in the description box thanks for watching signing off for today this is Manish from Rebellion Rider