Re: Making a user 'read only'

From: Heidi Thorpe <heidi_thorpe_at_hotmail.com>
Date: Wed, 14 Mar 2001 23:34:59 +1100
Message-ID: <gxJr6.3300$zW2.139281@ozemail.com.au>

Hi,

you could always use PRODUCT_USER_PROFILE

insert a record such as the following

SQL*Plus <userid> INSERT <> <> DISABLED <> <>

this will disable the insert command for the user in SQL*Plus. There are more details in the SQL*Plus documentation and in the

Oracle8i Tuning and Administration book by Heidi Thorpe

regards,
Scott
Alex <x17_at_oops.org.uk> wrote in message
news:3AAD5834.CF1857D6_at_clockworkweb.com...
> Hi,
>
> I'm looking for a way to revoke all object privileges except SELECT on a
> user's *own* objects.
> Or for some other way to produce the same effect: that a user, although
> able to log in and read
> data from their tables, is unable to write. This is for an 8.0.5 server.
>
> I need to be able to do this at a user level -- so making the database
> read only isn't an option,
> nor is making their tablespace read only possible, as many users share a
> tablespace.
>
> I thought this would be a facile operation but, unless I'm missing the
> blindingly obvious[1], this doesn't
> appear to be the case.
>
> Cheers,
>
> [1] -- This is far from impossible.
> --
> Alex Hooper
>
Received on Wed Mar 14 2001 - 06:34:59 CST