Tag Archives: Oracle

Getting List of Users and Roles on Oracle DB

Posted on January 24, 2014 by SoCRaT

This is a simple SQL statement to get you a list of all users and their roles in the Oracle DB: “SELECT * FROM DBA_role_privs;” And if you want to get the list of users related to a specific role, … Continue reading →

Posted in Uncategorized | Tagged , , , , , , , , | Leave a comment

How to determine history of DB startup in Oracle 11g

Posted on September 29, 2013 by SoCRaT

SQL> SELECT STARTUP_TIME FROM dba_hist_database_instance ORDER BY startup_time DESC; STARTUP_TIME ————————————————————————— 29-SEP-13 03.43.07.000 AM 29-SEP-13 03.42.31.000 AM 29-SEP-13 03.12.45.000 AM 29-SEP-13 03.11.28.000 AM 28-SEP-13 11.56.35.000 PM 07-SEP-13 10.04.07.000 PM 6 rows selected. Credit goes to Abdulrahman Galal from Oracle.

Posted in Uncategorized | Tagged , , , | Leave a comment

How to list the security adapter for an Object Manager in Siebel

Posted on May 26, 2013 by SoCRaT

list parameter SecAdptMode for comp comp_name e.g. list parameter SecAdptMode for comp eCommunicationsObjMgr_enu sample output for LDAP authentication: PA_ALIAS     PA_VALUE  PA_DATATYPE  PA_SCOPE   PA_SUBSYSTEM      PA_SETLEVEL  PA_DISP_SETLEVEL     PA_EFF_NEXT_TASK  PA_EFF_CMP_RSTRT  PA_EFF_SRVR_RSTRT  PA_REQ_COMP_RCFG  PA_NAME ———–  ——–  ———–  ———  —————-  ———–  ——————-  —————-  —————-  —————–  … Continue reading →

Posted in Uncategorized | Tagged , , , , , , , , | 1 Comment

Configuration for BI Publisher Server Level Log

Posted on February 26, 2013 by SoCRaT

Here are the steps to change your BI Publisher Enterprise Server to be in a debug mode: Login to BIP as Administrator Select Admin -> System Maintenance -> Server Configuration Change Debug Level to ‘Debug’ under General Properties Click on … Continue reading →

Posted in Oracle | Tagged , , , , , , , | Leave a comment