Grant insert, select , update ,delete from one schema to another user
737444Jan 14 2010 — edited Jan 14 2010Hi All,
can I grant insert, select , update ,delete from one schema objects to another user in one command?
Like I have a empty schema, I want to grant all select,update,insert on objects which will be created in future in this schema to another user?
Is it possible without the scripts which will collect table names from user_tables?
Thanks
Abhinav