Re: Make table read-only

"Ralf Zwanziger" <ralf_on_duty_at_gmx.de> wrote in message news:7n57n0t979rtkrvpcploqj7u37fqk9k6gu_at_4ax.com...
| Is ist possible to make an oracle table read-only?
| (without moving it to a read-only tablespace).
| I haven't found any command like "alter table xxx read only" in the
| docs.
|
| Bye,
| Ralf
|

the owner (owning schema) always has full privileges -- if you just grant SELECT to end-users (end-user schemas) then the table is read-only to them

are you targeting security issues or backup issues?

++ mcs Received on Mon Oct 18 2004 - 05:42:29 CDT