I have created a oracle instance in ORACLE 9i.
I have created a user "admin" and create a lot of tables and object
belongs to user "admin". And now, I need to create another user
"operator" who just only can SELECT, INSERT, UPDATE and DELETE on all
tables of schema "admin".
Therefore, I grant SELECT, INSERT, UPDATE and DELETE of all objects
under "admin" to "operator" and using the following command when
ALTER SESSION SET CURRENT_SCHEMA= admin;
it is successfully the "operator" operate on all tables of "admin" but
cannot ALTER tables, but it is very ...