Skip to Main Content

SQL & PL/SQL

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 create two schema owners?

3698762May 21 2018 — edited Jun 19 2018

Hi,

I have a schema with name EMPLOYEE. I have created 2 users EMP1 and EMP2. I want to make both users as the schema owner. Schema owner in the sense both the users should have the same privileges. there should not be any difference between the owners. As of now EMP1 is the schema owner and i have created EMP2 and given all the privileges to access/edit the object and also created log on trigger to make the default schema as EMPLOYEE. Still EMP1 and EMP2 has some differences.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 17 2018
Added on May 21 2018
35 comments
3,528 views