oracle - grant all privileges to schema

Question

i've used mysql before and i'm now switching to oracle.

I've already created a user in oracle. Now i want to give it "all privileges" for a schema.

In mysql i can give all privileges (DML/DDL) for a schema "mySchema" without grant (DCL) like this:

GRANT ALL PRIVILEGES ON mySchema.* TO 'user';

What's the oracle equivalent?

Answer 1

It's quite the same:

GRANT ALL ON yourSchema.* TO (...)

whereas (...) is PUBLIC, 'username' (optionally followed by IDENTIFIED BY 'password') or a specific role you defined earlier.

See here for a more detailed explanation: http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9013.htm