Oracle : Grant Create table in another schema?

Question

I have two users : Schema1 and Schema2 How to grant Create Table privilege On Schema2 to Schema1 ? I have been turning around and I got confused. I tried : From Schema2 I tried, ``` GRANT CREATE TABLE TO SCHEMA1 WITH ADMIN OPTION; ``` But it seems like this grants Creating table to Schema1 in its own Schema and not in the Schema2. Any ideas please ? Thank you.

Accepted Answer

The only other way to allow a non-DBA user to create a table in another schema is to give the user the `CREATE ANY TABLE` system privilege.

This privilege can only be given to `SCHEMA1 by a user having the CREATE ANY PRIVILEGE` privilege.

Oracle : Grant Create table in another schema?

Solution

Problem