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,

• LM