select grantee, privilege, admin_option from sys.dba_sys_privs
where (privilege like '% ANY %' or privilege in ('BECOME
USER', 'UNLIMITED TABLESPACE') or admin_option = 'YES') and
grantee not in ('SYS', 'SYSTEM', 'OUTLN',
'AQ_ADMINISTRATOR_ROLE', 'DBA',
'EXP_FULL_DATABASE', 'IMP_FULL_DATABASE',
'OEM_MONITOR', 'CTXSYS', 'DBSNMP', 'IFSSYS',
'IFSSYS$CM', 'MDSYS', 'ORDPLUGINS', 'ORDSYS',
'TIMESERIES_DBA')
Latest postings
Appraisal हमेह्सा की तरह 10 बजे
ठुमकते हुए office आया,11 बजे तक
नाश्ता क...
more >>
finding installed patches in apps select DRIVER_FILE_NAME from AD_PATCH_DRIVERS/select DRIVER_FILE_NAME
from AD_PATCH_DRIVERS where DRIVER_FILE_NAME like '%3258830%';5. Pin
SGA package...
more >>
Oracle applications version details Oracle Apps Version
select release_name from apps.fnd_product_Groups;
Application AD patch set
select patch_level from fnd_product_installation...
more >>
Important tables in oracle APPS Concurrent Manager
FND_CONCURRENT_QUEUES FND_CONCURRENT_PROGRAMS FND_CONCURRENT_REQUESTS
FND_CONCURRENT_PROCESSES FND_CONCURRENT_QUEUE_SIZE
FND
...
more >>
trigger for preventing tools on oracle DB CREATE OR REPLACE TRIGGER block_tools_from_prod AFTER LOGON ON
DATABASEDECLARE v_prog sys.v_$session.program%TYPE;BEGIN SELECT
program INTO v_prog ...
more >>