the user can drop abjects when he work in tablesplace read-only
كيف نستطيع منع user يعمل على tablesplace read-only من drop or trancate objects و نقيده فقط بعمليات select و شكرا

salaam

there is new way to do that if the user has privilage to drop he can drop in any tablespace
mode so better revoke the privilage from him.

sorry i want to say no way but i wrote new way