Adding Oracle ‘dba’ group to Ubuntu User

1- Go to System->Administration->Users and groups.

Then select the “Group” tab, search for the “dba” group, click on properties and select your user moving from the pane on the left to the pane on the right. Accept the modification and you’re done.

2- use usermod from a terminal to add your user to the group:

sudo usermod -a -Gdba stan

Although I would recommend you keep starting and stopping the database with the oracle default user (just su – oracle in the terminal when you need to do it). It’s like the concept behind the “sudo” command in ubuntu: you’re protecting the user and yourself from mistakes, other people accesing your machine.

Advertisement