DBA role for anyone?

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?

Oracle 12.2 COLLATE BINARY_CI

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

ORA-1246 TNS:permission denied

  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  

New Oracle Security On-Line Training Dates Added — Pete Finnigan’s Oracle security weblog

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