Wednesday, March 28, 2012

Check which generic users are active in your Apps 12.1.x instance

/* Formatted on 28-Mar-12 3:22:03 PM (QP5 v5.163.1008.3004) */
SELECT a.user_name,
   a.description,
   a.email_address email_address,
   a.start_date,
   a.employee_id,
   a.password_lifespan_days
  FROM fnd_user a
 WHERE a.end_date IS NULL
   AND a.user_name IN
      ('GUEST',
     'AME_INVALID_APPROVER',
     'ANONYMOUS',
     'APPSMGR',
     'ASGADM',
     'ASGUEST',
     'AUTOINSTALL',
     'BOL-OPS',
     'BOL-SETUP',
     'BOL-SUPPORT',
     'CONCURRENT MANAGER',
     'FEEDER SYSTEM',
     'IBE_ADMIN',
     'IBE_GUEST',
     'IBEGUEST',
     'IEXADMIN',
     'INITIAL SETUP',
     'IRC_EMP_GUEST',
     'IRC_EXT_GUEST',
     'MOBILEADM',
     'MOBADM',
     'MOBDEV',
     'OP_CUST_CARE_ADMIN',
     'OP_SYSADMIN',
     'PORTAL30',
     'PORTAL30_SSO',
     'STANDALONE BATCH PROCESS',
     'SYSADMIN',
     'WIZARD',
     'XML_USER',
     'ORACLE12.0.0',
     'ORACLE12.1.0',
     'ORACLE12.2.0',
     'ORACLE12.3.0',
     'ORACLE12.4.0',
     'ORACLE12.5.0',
     'ORACLE12.6.0',
     'ORACLE12.7.0',
     'ORACLE12.8.0',
     'ORACLE12.9.0',
     'INDUSTRY DATA',
     'ASADMIN',
     'OA_IMPLEMENTER',
     'PASYSADMIN',
     'MFG',
     'PRESETUP',
     'SETUP',
     'CONVERSION',
     'CONVERSIONS')

2 comments:

Anonymous said...

louis vuitton outlet, nike air max, polo ralph lauren outlet, ray ban sunglasses, louis vuitton outlet, cheap oakley sunglasses, prada handbags, ugg boots, louis vuitton, chanel handbags, air max, oakley sunglasses, tiffany jewelry, air jordan pas cher, uggs on sale, oakley sunglasses, louis vuitton, jordan shoes, tory burch outlet, sac longchamp, kate spade outlet, louboutin shoes, louboutin pas cher, burberry, longchamp outlet, replica watches, louis vuitton, ray ban sunglasses, nike outlet, michael kors, ray ban sunglasses, nike free, longchamp pas cher, nike roshe run, oakley sunglasses, louboutin outlet, nike air max, longchamp, tiffany and co, christian louboutin outlet, nike free, louboutin, prada outlet, ugg boots, gucci outlet, oakley sunglasses, replica watches, ralph lauren pas cher, polo ralph lauren outlet, longchamp outlet

Anonymous said...

beats by dre, lululemon, vans, nike trainers, reebok shoes, ghd, giuseppe zanotti, nfl jerseys, soccer shoes, longchamp, gucci, soccer jerseys, louboutin, babyliss, mac cosmetics, nike air max, nike air max, celine handbags, converse outlet, iphone cases, herve leger, nike roshe, wedding dresses, oakley, chi flat iron, ralph lauren, north face outlet, lancel, ray ban, birkin bag, timberland boots, valentino shoes, instyler, hollister, ferragamo shoes, hollister, new balance, mcm handbags, jimmy choo shoes, insanity workout, north face outlet, asics running shoes, vans shoes, bottega veneta, abercrombie and fitch, baseball bats, hollister, p90x workout, nike huarache, mont blanc