Hi Andreas,
I would suggest following construction:
- create a schema TABLE_OWNER, which holds all application objects as
tables, views and packages
- create one or more appropriate roles to which you grant the
necessary SELECT, INSERT, EXECUTE etc privileges
- grant the role(s) to your users
That way you can revoke the role from your users, when necessary. The
changed privileges take effect immediately.
Another solution may be to change the users' passwords temorarily.
On Thu, 27 Dec 2001 08:40:30 +0100, Andreas Wizemann
<AWizemann_at_fvvag.de> wrote:
>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
regards
Marc Blum
mailto:marc_at_marcblum.de
http://www.marcblum.de
- WAS CANCELLED BY =======:
Path: news.sol.net!spool0-nwblwi.newsops.execpc.com!newsfeeds.sol.net!priapus.visi.com!news-out.visi.com!hermes.visi.com!newspeer.monmouth.com!newsfeed.mathworks.com!wn3feed!worldnet.att.net!198.6.0.123!uunet!sac.uu.net!lax.uu.net!news.navix.net!u-n-c-a-n-c-e-l-l-e-r
From: marc_at_marcblum.de (Marc Blum)
Newsgroups: alt.config,comp.lang.c,comp.databases.oracle.server
Subject: cmsg cancel <3c2d80a5.429677_at_news.online.de>
Control: cancel <3c2d80a5.429677_at_news.online.de>
Date: Mon, 31 Dec 2001 06:59:51 GMT
Organization: Navix Internet Subscribers
Lines: 2
Message-ID: <cancel.3c2d80a5.429677_at_news.online.de>
NNTP-Posting-Host: 166.102.15.34
X-Trace: iac5.navix.net 1009788939 26548 166.102.15.34 (31 Dec 2001 08:55:39 GMT)
X-Complaints-To: abuse_at_navix.net
NNTP-Posting-Date: 31 Dec 2001 08:55:39 GMT
X-No-Archive: yes
Comment: Anarchy! Fuck You!
X-Commentary: I love NewsAgent 1.10, Sandblaster Build 74 (19 March 1999) and the Polaris Cancel Engine V. 6.1
X-Unacanc3l: yes
This message was cancelled from within Mozilla...not
Received on Sat Dec 29 2001 - 02:42:28 CST