Question: 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

1 Expert Approved Answer
Step: 1 Unlock

It seems like youre dealing with Oracle Databaserelated tasks and have encountered several issues along the way Lets break down your questions and iss... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!