changing the authorization of the tablespace's tables

[Maryan]

Hi everybody,

i would like to set the tables of a tablespace to readonly. I have done the following steps:

1. changed to the directory where the .DAT (Tables) and .INX (indexes) Files are.

2. changed the authorization of .DAT and .INX as follows:

RM and then properties->security-> revoke the permissions "Modify" and "write"

But after this change, the select doesn't work too and i get the following message:
SQL0970N The system attempted to write to a read-only file.
Does anyone know why the select does not work?

could you write me please if you know the answer.

thanks in advance.

Best regards,
Maryan

[sansaniwal12]

Databases not only write actual data in tables, it also writes control information, object space map for the objects in that tablespace. So database needs full access on that tablespace directory/datafiles and its underlying files wherever your tablespace files exist.

First, switch back the permission for .DAT & .INX to original.
Second, You can implement this requirement by setting appropriate privileges.