Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to grant DDL privileges only on a specific schema?

VinayakChendakeJan 24 2017 — edited Feb 17 2017

Hi All,

Below is my environment:

DB: Oracle 11GR2 standard edition

OS: Windows Server 2008 64 bit

CREATE ANY TABLE will give rights to create table in any schema in a database. I am looking for a solution where I can - grant DDL privileges only on a specific schema in a database.

For example:

If I have 3 schemas USER01, USER02 & USER03.

I want to give rights to USER01 so that he will be able to CREATE TABLE in only USER02 & NOT in USER03.

How can it be done?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 17 2017

Added on Jan 24 2017

#database-security, #database-security-general

7 comments

9,824 views