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 - 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...
    • OIM API - How to Get Members of Admin Role?
      public void getAdminRoleMembers(String adminRolename) {     String logp = CN + "getAdminRoleMembers";     logger.info(logp + ...
    • OIM 11g R2 PS3 - Adding UDF(User Defined Field) or Custom Field on Create User Page.
        Below table will give you quick reference for selection of data components and view objects for UDFs on different User page. ...
    • 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...

    About Me

    Anand Raj Badal
    View my complete profile

    Linked in

    Total Pageviews

    anandrajbadal.blogspot.in. Powered by Blogger.