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
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...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started