Oracle Database Discussions

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 give DML and DDL access to a user on schema

2684285Jul 27 2016 — edited Oct 29 2016

Hi Experts,

I often getting confusion, can you please help me below of my question,

user name = User_A

Schema Name=Schema_A

Now I need to give DML access like User_A has to get DML(insert,update,delete) access on schema called Schema_A

like I need give DDL access like User_A has to get DDL(create,alter,drop) access on schema called Schema_A

How can I get this. can you please help me. Thanks in advance.

This post has been answered by AndrewSayer on Jul 27 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 24 2016

Added on Jul 27 2016

#general-database-discussions

1 comment

1,180 views