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: Posts (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 - How to Remove Assigned Proxy from User?
      To execute below code you have to add following jars in classpath: commons-logging.jar eclipselink.ja...
    • OIM - How to Migrate User's Proxy from one environment to other environment in OIM?
      First export proxy details from source OIM :- Execute below SQL query to get all proxy assigned for users: SELECT DISTINCT USR.US...
    • OIM - SQL query to get all proxy assigned for users.
      SELECT DISTINCT USR.USR_LOGIN "User_Login",  PU.USR_LOGIN "Proxy_User_Login", TO_CHAR(P.PXD_START_DATE,'DD-MON-Y...
    • OIM API - How to Get Members of Admin Role?
      public void getAdminRoleMembers(String adminRolename) {     String logp = CN + "getAdminRoleMembers";     logger.info(logp + ...
    • 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 ...

    About Me

    Anand Raj Badal
    View my complete profile

    Linked in

    Total Pageviews

    anandrajbadal.blogspot.in. Powered by Blogger.