Grant all on To Oracle User on Another Schema

Recently I had the situation Where I have to given to all privileges to User on another schema. I am hesitated to give dba  privileges to user since he can access to anything in the database.  So here is the script to grant all privileges to user on another schema.




SELECT 'GRANT ALL ON '||table_name||' TO SUNIL;' FROM   ALL_TABLES WHERE  OWNER = 'KUMAR';

Once granted all on tables in KUMAR schema from that point User can do whatever he want on that schema.

Disclaimer: If you feel this content related to your content  please feel to contact me to remove this information.  I am sharing the knowledge with people whoever in the need which is learning daily basis