Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to restrict connections but allow export

Re: How to restrict connections but allow export

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Mon, 29 Dec 2003 22:58:11 +0100
Message-ID: <g081vv4qf8p76n2a1kdlvfphgb363oqvgp@4ax.com>


Daniel Morgan <damorgan_at_x.washington.edu> wrote:

>Why are you using SYS for exports? Create an OPS$ account as suggested
>by Tech Geek or, assuming you have actually set up roles that reflect a
>proper security heirarchy ... just remove CREATE SESSION from your base
>role.

The scripts used are kind of "legacy" from my predecessor.

All right, it is time to reconsider the accounts.

Thanks for your suggestions.

Rick Denoire Received on Mon Dec 29 2003 - 15:58:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US