Created
May 14, 2024 19:21
-
-
Save dincosman/f910d8791447d49c3e02ce7f029eb992 to your computer and use it in GitHub Desktop.
SQL commands used to enable ORDS for a user
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [oracle@oradev01 ~]$ sqlplus system/oracle@FREEPDB1 | |
| SQL> create user insanedba identified by insane; | |
| SQL> grant connect,resource to insanedba; | |
| SQL> grant SODA_APP to insanedba; | |
| SQL> alter user insanedba quota unlimited on users; | |
| [oracle@oradev01 ~]$ sqlplus insanedba/insane@freepdb1 | |
| SQL*Plus: Release 23.0.0.0.0 - Production on Sat May 4 23:56:27 2024 | |
| Version 23.4.0.24.05 | |
| Copyright (c) 1982, 2024, Oracle. All rights reserved. | |
| Connected to: | |
| Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free | |
| Version 23.4.0.24.05 | |
| SQL> exec ords.enable_schema(true); | |
| PL/SQL procedure successfully completed. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment