| readonly [message #59018] |
Wed, 22 October 2003 03:19  |
M. Khaled
Messages: 67
Registered: April 2002
|
Member |
|
|
I WANT TO MAKE MY TABLE READONLY NOT TABLESPACE.
PLEASE HELP
|
|
|
|
| Re: readonly [message #59021 is a reply to message #59018] |
Wed, 22 October 2003 10:02  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
You cannot make a table READ ONLY in the same fashion as read only tablespaces, but there are ways, to prevent writes to this table..
i) Move the table to its own Tablespace and make that as READ ONLY
ii) Create a Pre Insert,Update,Delete trigger on the table that will just exit with an error message ..
iii) Just revoke Insert,Update,Delete privileges on the table from all users/roles..(ofcourse the owner can still write to it, but thats a conscious action on part of the DBA)
iv) Create a view on top of this table with READ ONLY option and use that instead.
-Thiru
|
|
|
|
| Re: readonly [message #59034 is a reply to message #59018] |
Fri, 24 October 2003 05:27 |
cmn
Messages: 19
Registered: March 2002
|
Junior Member |
|
|
|
You also can create synonym for the table and grant on select privilege to user.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
