Re: Lock Table

The lock table command will only protect the table as long as the session that issued the lock remains active so I would consider Maxim's idea of placing the table in a read only tablespace as being more practical. As mentioned a system event DDL trigger could be used to stop the drop providing the user is a regular user. A DBA id could get around this.

If creating a read only tablespace is not practical then you might consider replacing the table with a view to a replacement version of the table created under a different owner. You could then just grant select privilege with the grant option to the original owner. To owner A it would still appear that the table existed and they could grant others access to it, but they would not be able to drop it or perform any other DML operations.

HTH -- Mark D Powell -- Received on Fri Jun 17 2005 - 09:20:52 CDT