User SCOTT, who had the password TIGER, changed his password to something more secure, but has since forgotten it. If
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?