Re: Make App "Read-only"

meathammer wrote:
> Does that stop packages from doing U/I/D ? since roles are not enabled
> in packages....

Cannot see anything too wrong with putting tablespace read only, it also stops me as a user with dba rights to accidentaly change some non-changeable data :)
But one has to remember that read only tablespace doesn't prevent from DDL as in following example:
SQL> create table bla (a number) tablespace users;

Table created.

SQL> alter tablespace users read only;

Tablespace altered.

SQL> insert into bla values (1);
insert into bla values (1)

            *
ERROR at line 1:
ORA-00372: file 9 cannot be modified at this time ORA-01110: data file 9: '<path>/users01.dbf'

SQL> drop table bla;

Table dropped.

Gints Plivna
http://www.gplivna.eu Received on Tue Jul 25 2006 - 01:08:56 CDT