Forum Stats

  • 3,769,290 Users
  • 2,252,943 Discussions
  • 7,874,980 Comments

Discussions

Install oracle 10g server visible to a particular user.

597517
597517 Member Posts: 3
edited Aug 26, 2008 4:18AM in Database Installation
Hi All,
I want to install oracle 10g which is visible only to my user id. I want the installation to be completely hidden to other user account on the server machine. In a way no one else should be in a position to access any of the tools of oracle server. However isqul plus should be readily available to anyboby.

Regards.
Kanhaiya

Email: [[email protected]]
Tagged:

Comments

  • 247514
    247514 Member Posts: 10,875 Bronze Trophy
    The Oracle installation should be done using umask 022, which will leave no other regular users has any access to Oracle installation. Except, one in dba group or root.

    Please also note, isqlplus is depreciated in 11g.
  • 597517
    597517 Member Posts: 3
    I am really unknown with umask 022. Please elaborate on using umask 022. Is umask 022 a software or a part of oracle installation.
  • Sabdar Syed
    Sabdar Syed Member Posts: 1,881
    UMASK is an Unix/Linux environment variable, which will set the default permissions whenever a file is created on Unix with the permission you set with UMASK.

    To understand more about UMASK Environment variable, please take a look at the below URL.

    http://www.tech-faq.com/umask.shtml

    Regards,
    Sabdar Syed
  • 597517
    597517 Member Posts: 3
    Hi,
    I want the installation to be done on windows XP then what should be done???
    Thanks
  • Sabdar Syed
    Sabdar Syed Member Posts: 1,881
    What's the problem in installing the Oracle 10g on Windows XP?

    If at all, you want to restrict users to not to connecto the database you installed and created, do not share the database userid and passwords or add/remove the OS Users from ORA_DBA and ORA_OPER Groups.

    Check the below link to do so.

    The Operating System: Some important groups on Windows

    http://www.databasejournal.com/features/oracle/article.php/3483966

    Regards,
    Sabdar Syed,
    http://sabdarsyed.blogspot.com
This discussion has been closed.