This discussion is archived
6 Replies Latest reply: Jan 21, 2011 8:02 AM by 824346 RSS

sql*NAT?

832907 Newbie
Currently Being Moderated
Hi every one,

This is my third week working at a DBA job, i have worknig with oracle 91, 10g and 11g for nearly three years managing RAC and doing lots of PL/SQL (for the last 2 years :-S)but i havent ¿securize? neither the OS or the database, so im a little lost since this evening, at work, my responsible have asked me to see how to securize things...so as users can't ¿snip? around.

I have googled for a while and found this interview to Arup Nanda

"What are some of the most fundamental security precautions that companies can take to protect their Oracle database?
Arup Nanda: Securing Oracle is not difficult, but some companies don't follow the most basic steps. Actually it only takes a little bit of diligence and systematic thinking. The first is making sure that the Listener service is kept up to date and that a password is set on it. Companies also fail to realize that by using *_Oracle's SQL*NAT function_*, you can create a simple firewall for the database at no additional cost. Lastly, Oracle's row-level security feature provides access control at the individual row level. Rather than opening up an entire table to any individual user who has any privileges on the table, row-level security restricts access to specific rows in a table."

and i asked my self what is this SQL*NAT function.

Can anyone please explain to me?, if so, i'll be very thankfull. And if someone can give a hand explaining to me some first step on securizing OS or database it would be just great.

Thanks to all, and sorry if i make some gramatical/ortographical mistakes. Thanks a lot.
Ana.

erm, i have just see where i have posted this ... sorry i will try to reallocate this post.

Edited by: user12302245 on 20-ene-2011 8:12
  • 1. Re: sql*NAT?
    824346 Explorer
    Currently Being Moderated
    Basically you can control who can access the database by creating netowrk based rules.
    Check this out for more info. http://www.orafaq.com/wiki/SQL*Net_FAQ

    Regards,
    RK
  • 2. Re: sql*NAT?
    832907 Newbie
    Currently Being Moderated
    Many thanks, but i still can't see how can i securize the OS from some users.

    again, many thanks! ^^
  • 3. Re: sql*NAT?
    824346 Explorer
    Currently Being Moderated
    you can not secure the OS using oracle. As a DBA I assume your responsiblities would be to restrict the access to database. You can control many logon parameters using the fine grain auditing. Search for "fine grain auditing on oracle". You should find more information about what you are looking for.

    http://www.oracle.com/technetwork/database/security/index-083815.html
  • 4. Re: sql*NAT?
    832907 Newbie
    Currently Being Moderated
    finally the solution was another.

    The point was creating a client user with another group (not oinstall) so as those users couldn't rm files/dirs of oracle or messing around the oracle software ... i wasn't able to see it, i was too nervous :-s

    many thanks for your posts rkrishna ^^. If i need to securize database i have something to start with :-D.
    Ana.
  • 5. Re: sql*NAT?
    Nicolas.Gasparotto Oracle ACE
    Currently Being Moderated
    I'm wondering how it is Peoplesoft related though.
    Should be rather posted in Database General forum : General Questions

    Nicolas.
  • 6. Re: sql*NAT?
    824346 Explorer
    Currently Being Moderated
    Nicolas, This one of the steps we use to secure our peoplesoft environment. We restrict access to the db from our appservers and process schedulers using fine grain auditing. You are right, maybe someone in the dba group might be able to help her better.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points