Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to connect to the human_resources schemas in 12c?

9a8s7d6f5g4h3j2k1lJan 28 2014 — edited Jan 29 2014

Hi, i didnt have hr user, i didnt have schemas, so i download the example schemas from oracle downloads. Installed them to F:\app\product\12.1.0\dbhome_1\demo\schema\human_resources

Here goes the question, do i have now HR user? or must create the new one? And, if i must create new one, how can i grant him privilege to acces those schemas

In SQL Developer for user SYSTEM, show me other tables that i dont need right now. So how can i solve this problem?
Please write commands for SQL plus because i am new in this. Thank you.

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

PL/SQL Release 12.1.0.1.0 - Production

"CORE 12.1.0.1.0 Production"

TNS for 64-bit Windows: Version 12.1.0.1.0 - Production

NLSRTL Version 12.1.0.1.0 - Production
This post has been answered by Richard Harrison . on Jan 29 2014
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 26 2014
Added on Jan 28 2014
#general-database-discussions
42 comments
18,606 views