| locking user's own tables from updation [message #53141] |
Thu, 29 August 2002 01:13  |
M.POORNIMA
Messages: 1
Registered: August 2002
|
Junior Member |
|
|
There is an option to lock tables from updation,deletion etc by other users.
We need to lock the tables from updation,deletion even by the user himself.
let me know if any method is available to lock the tables so that only querying is the only option to be available to all the users and user who has created the tables.
thankyou
poornima
|
|
|
|
| Re: locking user's own tables from updation [message #53159 is a reply to message #53141] |
Thu, 29 August 2002 09:12  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
You could rename the table and replace it with a read only view (but the renamed table is still open).
You can move the table and it's indexes to a separate tablespace and then set the TS to read only.
You can add a before insert/update/delete trigger to the table which simply does a:
raise_application_error(-20501, 'Table X is read only');
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
