How can I grant a privilige to User2, so he can only create tables for User1?
I know there are CREATE TABLE and CREATE ANY TABLE system privileges, but CREATE TABLE privilege is for creating tables for own and CREATE ANY TABLE is for creating tables for any one else, not for a particular user.
USER1 should create a PL/SQL procedure that creates a table (using dynamic SQL). Then he grants the EXECUTE on this procedure to USER2 - now USER2 can create tables under USER1's schema, while other users can't, unless they have CREATE ANY TABLE privs.
Thanks for the reply.
I am totally new to Oracle (acturally new to database too). It will be great if you could show me what scripts look like.
I really appreciate your kind help.