Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

User SCOTT, who had the password TIGER, changed his password to something more secure, but has since forgotten it. If possible, demonstrate what you as

User SCOTT, who had the password TIGER, changed his password to something more secure, but has since forgotten it. If possible, demonstrate what you as a DBA can do to give SCOTT access to his account. Other users need access to the tables belonging to IGGY. Make a role named CLERK that has SELECT privileges, for tables PART, SUPPLIER, and QUOTE. Assign the role CLERK to user SCOTT. Connect as user SCOTT and SELECT * FROM IGGY.QUOTE to demonstrate that SCOTT has access to IGGY's tables.

 

When creating a role I run into this error saying that:

ORA-65096: invalid common user or role name

 

After trying to Google such problem it says I need to login as SYSDBA it says I need to login to PDB and not CDB as you cannot create roles there? Now trying to login to PDB it says my username is wrong and logged me out for 3 failed attempts. 

How do I find my username and password to the level of SYSDBA? How do I get into @PDBORCL compared to being in @ORCL?

Step by Step Solution

3.40 Rating (147 Votes )

There are 3 Steps involved in it

Step: 1

It seems like youre dealing with Oracle Databaserelated tasks and have encountered several issues along the way Lets break down your questions and iss... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of Case Management Practice Skills for the Human Services

Authors: Nancy Summers

5th edition

1305094765, 130509476X, 9781305544833 , 978-1305094765

More Books

Students also viewed these Databases questions