Anand's Oracle Identity Management Blog

  • Home
  • OIM
  • OIM APIs
  • SOA
  • Installation
  • Database
  • Linux

Database :-

  • How to increase value of open_cursors and processes in Oracle DB.
  • SQL query to find SID in Oracle database.
  • SQL query to find 'Service Name' in Oracle database. 
  • How to open sqlplus in linux. 
  • Create auto increment field in Oracle database. 
  • Change character set in oracle database - AL32UTF8. 
  • Create and Configure a Database using Database Configuration Assistant(DBCA).
  • Delete a Database using Database Configuration Assistant(DBCA).
  • SQL query to get all proxy assigned for users.
  • SQL query to get all the entitlements provisioned to the user.
  • SQL query to get all the User's provisioned/enabled accounts.
  • SQL Query to get all the members of specific Role.
  • SQL Query to get all the members of specific Admin Role.
  • SQL Query to get all the Users having specific entitlement provisioned.
  • SQL Query to get all the Users having specific account provisioned.
  • SQL Query to Clean up bad/unused accounts.
    Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

    No comments:

    Post a Comment

    Home
    Subscribe to: Comments (Atom)

    Translate

    Search Post

    Blog Archive

    • ▼  2019 (13)
      • ▼  April (2)
        • OIM Certification - Modify Composite to have all t...
        • OIM - How to Add User Defined Field(UDF) in Certif...
      • ►  March (6)
      • ►  February (2)
      • ►  January (3)
    • ►  2018 (59)
      • ►  June (18)
      • ►  April (9)
      • ►  March (32)
    • ►  2017 (31)
      • ►  December (7)
      • ►  September (17)
      • ►  July (3)
      • ►  February (4)
    • ►  2016 (38)
      • ►  December (5)
      • ►  October (2)
      • ►  September (3)
      • ►  July (1)
      • ►  June (2)
      • ►  May (16)
      • ►  February (9)
    • ►  2015 (19)
      • ►  December (18)
      • ►  July (1)
    • ►  2014 (3)
      • ►  September (1)
      • ►  August (2)

    Popular Posts

    • OIM API - All User Operations.
          //Create user in OIM     public void createUser(){         String userLogin = "A12345";         String fName = "Anand...
    • OIM API - Stand Alone Code to add Process Task for Bulk Users.
      To execute below code you have to add following jars in classpath: commons-logging.jar eclipselink.jar ...
    • OIM API - Stand Alone Code to Provision Account to User.
      To execute below code you have to add following jars in classpath: commons-logging.jar eclipselink.jar jr...
    • How to add UDF i.e custom attribute to catalog in OIM 11gR2PS3.
      ·          Go to System Administrator console. ·          Click on Sandboxes, shown in below screen shot.   ...
    • OIM 11g R2 PS3 - Adding UDF(User Defined Field) or Custom Field on Modify User Page.
        Below table will give you quick reference for selection of data components and view objects for UDFs on different User page. ...
    • OIM - SQL Query to get all the members of specific Role.
      SELECT UGP.UGP_NAME,USR.USR_LOGIN FROM UGP, USG, USR   WHERE USG.USR_KEY = USR.USR_KEY AND UGP.UGP_KEY = USG.UGP_KEY AND UPPER(UGP_NAM...

    About Me

    Anand Raj Badal
    View my complete profile

    Linked in

    Total Pageviews

    anandrajbadal.blogspot.in. Powered by Blogger.