Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> REPOST: Re: How to prevent users from access to my database ?
"Andreas Wizemann" <AWizemann_at_fvvag.de> wrote in message
news:b0kl2us6u4gjrn2lhp8vnhbjj2hicohdna_at_4ax.com...
> Hi,
> is there an (easy) way to prevent temporarly access to a database
> while there is a specific task running (e.g. a Batch-Job or some kind
> of maintenance) ?
>
> Regards
>
> Andreas Wizemann
You could issue:
SQL> alter system enable restricted session;
System altered.
[ do your work]
SQL> alter system disable restricted session;
System altered.
This would prevent any non-DBA's (and those not explicitly granted restricted session access) from connecting during your processing.
HTH,
This message was cancelled from within Mozilla...not Received on Fri Dec 28 2001 - 19:55:44 CST