I am having this below query.
Q) We have 2 schema A and B, Now i need to give permission Create table only in schema B to schema A.
SQL> Grant create table on B to A; ---------- Not Working
SQL> Grant create table to A; ----------- We don't provide
How can we give? Kindly suggest us here.
Thanks in advance.