GRANT EXECUTE on SYS Package to PUBLIC
We used the following SQL statement to retrieve and compose necessary GRANT statements for you to fix your compiler problems related to SYS's public packages,… Read More »GRANT EXECUTE on SYS Package to PUBLIC
SYS
SYS Packages Granted to Public
For your reference, here I list packages owned by SYS, which should be granted with EXECUTE privilege to PUBLIC in 19c. Theoretically, there's no need… Read More »SYS Packages Granted to Public
How to Install USER_LOCK Package
USER_LOCK USER_LOCK is not a default package of SYS, you need to install it before using it. SQL> conn / as sysdba Connected. SQL> @?/rdbms/admin/userlock.sql… Read More »How to Install USER_LOCK Package
Oracle Default User
Predefined and Customized Users Although we can look up the predefined accounts in the official documentation to make sure that we won't touch them in… Read More »Oracle Default User