Home / server / Questions / 335740
Accepted
JMW
Asked: 2011-11-30 03:30:49 +0800 CST

oracle - grant all privileges to schema

  • 772

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?

mysql oracle oracle-11g

1 Answers

  1. Best Answer

    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

    • 2