Problemm with dba group vs oinstall group
Hi to all ;
This is related to oracle as well as some os related security problems. please clarify it. I tried but couldn't solve it! All information's given here .. Testing from user 'A' PHP Code:
Testing From user 'b' : PHP Code:
PHP Code:
PHP Code:
USER 'a' belongs oinstall group. USER 'b' belongs dba group. My questions are : 1.why OS user can access database with oinstall group ? 2.why OS user can't access database with dba group ? Note: This is concept of oracle To connect as sysdba using OS Authentication ; UNIX OS user must be a part of OSDBA (dba) group. Once the user is part of OSDBA group. Quote:
Thiyagusham .G |
oinstall is for, well the INSTALLATION.
the dba designation is for the administration of the Oracle db, (after the install). what are the $PATH differences between A and B ? Code:
sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory Check the documentation. :) |
Actually, that would be the LD_LIBRARY_PATH https://kamranagayev.files.wordpress..._install22.jpg.
You're still going to have perm problems, as according to you (OP), only the oracle user or members of the oinstall group can run that code anyway.... Check the Oracle docs; you may need to add user b to multiple groups; oinstall and dba. |
Hi Chrosm01 , Habitual;
You are right. As Oracle user i don't have any problem. test DB works well. I tried to set OS authentication for limited OS users ( sam=a , sona=b) I was testing with user a and user b .. Quote:
So that i am asking .Kindly help me resolve this. |
Hi to all ;
"No need to add user b to multiple groups; oinstall and dba." This is the problem Quote:
|
Everything I learned about installing and configuring Oracle came from http://www.puschitz.com/OracleOnLinux.shtml
It's all "there" and at OTN |
Hello to all;
I suspect permissions set incorrectly. I tried to find file location but getting error. PHP Code:
|
Code:
sudo updatedb What does that have to do with oracle groups and sqlplus paths ? |
Hi Habitual;
Did u expect this ? Quote:
Quote:
|
Not really.
We have suggested group permissions and you are off trying to manipulate file permissions.... Since you can't stay on topic, or pursue the LD_LIBRARY_PATH path variable as Chris has suggested, I now exit the conversation. Database Administrator Authentication oinstall vs. dba UNIX Group What is LD_LIBRARY_PATH env variable for? Maybe Oracle is not suited for you? |
Hi habitual;
i did n't understand Maybe Oracle is not suited for you? Quote:
|
To OP: Well, if you are unfamiliar with linux, you should call oraenv, as Oracle suggests.
|
All times are GMT -5. The time now is 07:26 PM. |