Make Custom User Authorization Schemes. Oracle Apex. Part-1

Error- Ora-65096- Invalid Normal User Or Role Name In Oracle

 

An Attempt Has Been Made To Create An Ordinary User Or Role With An Invalid Name For Regular Users Or Roles. In Addition To Common User Rules And Role Names, Normal Users And Role Names Should Start With C ## Or C ## And Include ASCII Characters Only.

The Solution For Ora-06596 Is To Set The Hidden Parameter "_oracle_script". If You Set An Unwritten (Hidden) Parameter "_oracle_script" = True You Can Create An Uninstalled User Without C ## From The User Id. However, This User Will Not Be Able To Use The Utility On The Portable Website / Container:

Solution... Database 19c Invalid User Or Role Name

If You Insist On Creating Users The Wrong Way, Follow The Steps Below.

Open The Sql Window On Your Computer.

   # sqlplus /nolog 
   # conn sys as sysdba 
   
  SQL>  Alter Session Set "_ORACLE_SCRIPT"=true; 
  
  

1.First, Open The Sql Window On Your Computer. 

2. Sql > Sqlplus / As Sysdba 

3. Sql > Alter Session Set "_oracle_script"=true; 

4. Sql > Create User Test_user Identified By "Test123"; 

5. Close The Sql Window, Enter The Exit 

6. Open The Cmd Window On Your Computer. 

7. Sqlplus Test_user/test123@orclpdb As Sysdba 

8. Sql > Grant Connect To Test_user; 

9. Sql > Grant Create View To Test_user; 

10. Sql > Grant Create Table To Test_user; 

11. Sql > Grant Create Trigger To Test_user; 

 

 

Problem With Tablespaces And Quotas.....

 Sqlplus Sys/<your_admin_pws>@localhost/mydatabase As Sysdba 

List All Tablespaces 

 Select Tablespace_name, Status, Contents From User_tablespaces; 

Create A New Tablespace 

 Create Tablespace Tablespacename Datafile 'tablespace_datafile.dat' Size 10m Reuse Autoextend On Next 10m Maxsize 200m; 

Drop Your Tablespaces 

 Drop Tablespace Tablespacename Including Contents And Datafiles; 

Grant "Access" To The Tablespace 

 Alter User Test_user Quota Unlimited On Tablespacename; 

 

🔗 Demo Application-
            URL- Demo Application
            Username - demo, Pass- demo
 

I hope everyone will like it. Please watch the full video,
Comment on any of your problems, I will try my best to solve the problem, In-Shah Allah. Everyone's cooperation is desirable. Visit my blog site, new technology related videos, you will get different types of tutorials of Oracle Apex, and hopefully, you can use them in your daily work.
Please stay tuned by subscribing to the YouTube channel, and encourages new videos to be uploaded.
=================
Visit my site to get more collaborative posts about Oracle Apex and subscribe to my YouTube channel. Thanks.
Comment on any of your issues, I will try my best to solve the problem, In-Shah Allah. Everyone's cooperation is desirable.
Visit my blog site, new technology-related videos, you will get different types of tutorials of Oracle Apex, and hopefully, you can use them in your daily work.
==============================

🙍🏾‍ Md jABER HOSSEN
📲 Mobile- +8801760688286
📨 Email- jaberit786@gmail.com
🌐 FB- facebook.com/mdjaber.hossen1
Please Subscribe to My Channel

Many thanks for visiting the site.

Then Enjoy.........................