How to Add a User to Local Administrator Group

※ Download: Add windows user to ora_dba group

This behaviour can be changed via the -a option, which appends the user to the current supplementary group list. An icon for that shortcut appears on the desktop. If unsecured client machines can gain access to your network, then remote Windows authentication opens your database environment to unauthorized access.

However, when I restart I don't have an option to log in as administrator. If you want to create a new user during installation, then it can only be a Windows Local User. Otherwise, the user will be removed from any groups, not in the list. Oracle recommends that you use the standard Windows User Account instead of Windows Built-in Account as the Oracle Home User for enhanced security.

How to Add a User to Local Administrator Group - The second command line specifies the authentication credentials.

I've read the man page for useradd, but I'm not having any luck. It's not clear to me from the man page what options I should use to make this work. The command will try to add a new user. Since your user already exists this is not what you want. Instead: To modify an existing user, like adding that user to a new group, use the command. Try this: sudo usermod -a -G groupName userName The user will need to log out and log back in to see their new group added. Otherwise, the user will be removed from any groups, not in the list. Use only with the -G option. This behaviour can be changed via the -a option, which appends the user to the current supplementary group list. As dpendolino's mentioned, for the effects of this command to persist: sudo usermod -a -G groupName userName.

Create new connection with new user in Oracle SQL Developer
However, a Windows administrator can manage this account like any other Windows account. In the Computer Management windows, expand Local Users and Groups and select Groups. If you specify a non-existing user as the Oracle Home User, then the Windows User Account you specify must be a Windows Local User. Click Close to close the window. Members of this group have privileges necessary for performing encryption key management tasks on all database instances that run from the specified Oracle home directory. Table 9-3 Basic Features of User Authentication and Role Authorization Feature Description Authentication of external users Users are authenticated by the database using the user's Windows login credentials enabling them to access Oracle Database without being prompted for additional login credentials. Enter orcl for the Global Database Name and oracle for the Database Password and Confirm Password. Each enterprise role can be assigned to more than one enterprise user in the directory. Since your user already exists this is not what you want. Provide either the consent or your Windows Administrator credentials as appropriate. The Oracle Universal Installer starts.