DBA role grant to myselft (tested in 12.2) thanks to Pete Finnigan for explanation "this is not an exploit, this is due to the privileges granted" CREATE USER "TUSER" IDENTIFIED BY VALUES 'S:B368AC805D18763B7ABB524F49E264B5FB86C3A33574D41EEEEBCF96E08A;T:E1F2507A6EB276AF7C7C43FF1BBF5E BB31C5518EAA2E4F1EB1BB639D9B5A14C8D7AD4CF476D1C147C8869FE628963D2BA0C4808257D81DC81D5373CA2C3CAE739288D97C97F2D87E39069DB2E1F629DA' DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP"; -- Note: No TS Quotas found! GRANT "CONNECT" TO "TUSER" GRANT "RESOURCE" TO "TUSER" GRANT … Continue reading DBA role for anyone?
1st db went online a week ago sofar so good Issues PL/SQL compile 0/0 PL/SQL: Compilation unit analysis terminated 0/0 PLS-00761: Programmeinheitsortierung darf nur USING_NLS_COMP sein SQL> alter session set default_collation=USING_NLS_COMP; Triggers An error in trigger PLS-00049: bad bind variable after converting tables to COLLATE BINARY_CI; SR will be created CREATE TABLE "CI"."TESTTAB" ( "ID" … Continue reading Oracle 12.2 COLLATE BINARY_CI
schema B with default collation = BINARY_CI schema B with default collation = USING_NLS_COMP join tables from both schemas produces error ORA-43915: unable to determine collation: arguments have conflicting collations Solution recreate table in B schema with BINARY_CI R/
set permission on Oracle binary: cd $ORACLE_HOME/bin chmod 6755 oracle permissions on /oracle/xxxxxxxxxxx/dbms122/bin/oracle not correct /xxxi/hbai>ls -altr $ORACLE_HOME/bin/oracle -rwsrws--- 1 hsxxx dba 408095920 9. Aug 13:41 /oracle/xxxxxxxxxxx/dbms122/bin/oracle These are correct -rwsr-s--x 1 hsxxx dba 408095920 9. Aug 13:41 /oracle/xxxxxxxxxxx/dbms122/bin/oracle
We have finally added new on-line training dates for some of our classes; the very popular two days "How to perform a security audit of an Oracle Database" is first followed by the one day class "Hardening and Securing Oracle....[Read More] Posted by Pete On 07/08/17 At 06:30 PM via New Oracle Security On-Line Training Dates … Continue reading New Oracle Security On-Line Training Dates Added — Pete Finnigan’s Oracle security weblog