Databases
StackOverflow2013
Postsdbo
POHow user could connect SysDBA?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow user could connect SysDBA?
    primarykey
    data
    text
    <p>We Start Oracle AUDIT and Onlogon Procedure Auditing on our Database. We Confused, What SysDBA could connect to System. Is SysDBA Oracle User? In SQL*Plus has a command for this acction?</p> <p>Our On Logon PL/SQL code</p> <pre><code>CREATE OR REPLACE TRIGGER logon_audit_trigger AFTER LOGON ON DATABASE ... insert into logon_log (user_id , session_id , sid , serial# , host , ip_address , last_action , last_module , logon_day , logon_time , logoff_day , logoff_time , elapsed_minutes, elapsed_seconds) values( user, sys_context('USERENV','SESSIONID'), sys_context('USERENV','SID'), dbms_debug_jdwp.current_session_serial, sys_context('USERENV','HOST'), sys_context('USERENV','IP_ADDRESS'), action_name, module_name, lo_dt, to_char(lo_dt, 'hh24:mi:ss'), null, null, null, null ); </code></pre> <p>Select * From logon_log</p> <pre><code>USER_ID SESSION_ID SID SERIAL# HOST IP_ADDRESS LAST_MODULE LOGON_DAY JOHN 393900 282 1186 ERO\APPS 192.168.1.103 frmweb.exe 1/31/2013 9:27:49 AM JOHN 393903 189 1005 ERO\SECC 192.168.1.110 SQL*Plus 1/31/2013 9:28:12 AM JOHN 393929 167 288 ERO\SECC 192.168.1.110 plsqldev.exe 1/31/2013 9:38:37 AM JOHN 393930 198 858 ERO\SECC 192.168.1.110 plsqldev.exe 1/31/2013 9:38:37 AM JOHN 393983 179 6066 ERO\SECC 192.168.1.110 frmbld.exe 1/31/2013 9:58:21 AM JOHN 393987 182 231 ERO\SECC 192.168.1.110 frmbld.exe 1/31/2013 9:59:17 AM JOHN 393941 278 1429 ERO\SECC 192.168.1.110 plsqldev.exe 1/31/2013 9:42:26 AM JOHN 394060 305 1337 ERO\SECC 192.168.1.110 plsqldev.exe 1/31/2013 10:36:34 AM JOHN 394129 261 5236 ERO\SECC 192.168.1.110 plsqldev.exe 1/31/2013 11:16:40 AM JOHN 394196 269 783 ERO\SECC 192.168.1.110 SQL*Plus 1/31/2013 11:58:20 AM JOHN 394199 309 701 ERO\APPS 192.168.1.103 frmweb.exe 1/31/2013 12:00:04 PM JOHN 394240 196 578 ERO\SECC 192.168.1.110 SQL*Plus 1/31/2013 12:28:53 PM JPHN 394243 248 702 ERO\SECC 192.168.1.110 frmbld.exe 1/31/2013 12:30:56 PM SysDBA 394249 196 580 ERO\SECC 192.168.1.110 1/31/2013 12:31:56 PM JOHN 394252 248 704 ERO\SECC 192.168.1.110 frmbld.exe 1/31/2013 12:32:57 PM JOHN 394259 248 706 ERO\SECC 192.168.1.110 frmbld.exe 1/31/2013 12:35:29 PM JOHN 394263 196 587 ERO\SECC 192.168.1.110 SQL*Plus 1/31/2013 12:36:49 PM SysDBA 394264 196 589 ERO\SECC 192.168.1.110 1/31/2013 12:37:07 PM </code></pre> <p>Why UserID is SysDBA?</p> <p>Additional Data:</p> <pre><code>Select * From DBA_USER USERNAME SysDBA USER_ID 390 PASSWORD BD40E271960C5535 ACCOUNT_STATUS OPEN LOCK_DATE EXPIRY_DATE DEFAULT_TABLESPACE USERS TEMPORARY_TABLESPACE TEMP CREATED 8/1/2012 10:28:51 AM PROFILE DEFAULT INITIAL_RSRC_CONSUMER_GROUP DEFAULT_CONSUMER_GROUP EXTERNAL_NAME </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USMahdi Sabori
    1. USMahdi Sabori
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COYou need to talk to your DBA/the person who installed Oracle. SYSDBA is an Oracle system user with DBA privileges. You shouldn't really be using it. I find the capitalisation of that user suspicious (i.e. it might not be SYSDBA actually). Is it rendered as SYSDBA or SysDBA in your output?
      singulars
      1. POHow user could connect SysDBA?
      1. USBen
    2. COSysDBA in Output, This type of user confused us... select * from dba_user --> Result: 239 SysDBA 390 BD40E271960C5535 OPEN USERS TEMP 8/1/2012 10:28:51 AM DEFAULT DEFAULT_CONSUMER_GROUP
      singulars
      1. POHow user could connect SysDBA?
      1. USMahdi Sabori
    3. COIs this really the same issue as [your earlier question](http://stackoverflow.com/q/14545620/266304)?
      singulars
      1. POHow user could connect SysDBA?
      1. USAlex Poole
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload