Skip to content

How to Add User to OSDBA Group

  • Oracle

OSDBA Group

In the previous post, we have talked about how to enable an user other than administrator (Windows) or oracle (Linux) to use SQL*Plus in Oracle database server.

Additionally, to enable the user to connect to the database through OS authentication (as know as sqlplus / as sysdba), you need to add it to the OSDBA group.

The steps to add to OSDBA group is very different between Linux and Windows.

  1. Linux
  2. Windows

Linux

First of all, you should check the actual group name of OSDBA.

Suppose that the OSDBA group in your database server is called dba, we should add the user to the group in Linux.

[root@test ~]# usermod -a -G dba erp
[root@test ~]# id erp
uid=54322(erp) gid=54331(erp) groups=54331(erp),54322(dba)

Then we re-login the user and make a connection through OS authentication by the user.

[erp@test ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Sep 4 04:14:40 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle. All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL>

We made it.

Windows

To add an user to OSDBA group in Windows, we take the following steps.

Open Local Users and Groups Application

First of all, we should open the application for managing local users and groups in Windows, it's pretty easy.

Add to Group

Since OSDBA group is always ORA_DBA in Windows platform, so we search for ORA_DBA, right-click on it, then "Add to Group".

Add to Group "ORA_DBA"
Add to Group "ORA_DBA"

Add an User

Click on "Add".

Click on "Add"
Click on "Add"

Enter Username

Enter the username that you want to add, then click "Check Names".

Enter user name
Enter user name

Confirm Username

Click "OK" to confirm it.

Confirm the username
Confirm the username

Apply Change

Preview the result, then "Apply".

Apply the change
Apply the change

Close Dialog

Click "OK" to close the dialog.

Close the dialog
Close the dialog

OS Authentication Test

Then we sqlplus / as sysdba to connect to the database by the user.

sqlplus / as sysdba
sqlplus / as sysdba

We made it.

Leave a Reply

Your email address will not be published. Required fields are marked *