{"id":4130,"date":"2013-04-26T14:02:50","date_gmt":"2013-04-26T18:02:50","guid":{"rendered":"https:\/\/pitss.org\/us\/2013\/04\/26\/how-to-find-what-group-a-pitss-con-user-is-in\/"},"modified":"2017-05-15T14:27:58","modified_gmt":"2017-05-15T18:27:58","slug":"how-to-find-what-group-a-pitss-con-user-is-in","status":"publish","type":"post","link":"https:\/\/pitss.org\/us\/2013\/04\/26\/how-to-find-what-group-a-pitss-con-user-is-in\/","title":{"rendered":"How to Find What Group a PITSS.CON User Is In"},"content":{"rendered":"<p>There is no easy way to determine which group a PITSS.CON user belongs to inside PITSS.CON. To find what group a PITSS.CON user belongs to, you can run the following SQL:<\/p>\n<ol>\n<li>Log into SQLPLUS (or SQL Developer, Toad) as the MIG user<\/li>\n<li>Run the following SQL: select mig_pitsscon_users.user_name,mig_pitsscon_groups.group_name from mig_pitsscon_users inner join mig_pitsscon_groups on mig_pitsscon_users.group_id=mig_pitsscon_groups.group_id;<\/li>\n<\/ol>\n<p>You should see an output like below:<\/p>\n<p><a class=\"thickbox\" href=\"https:\/\/pitss.org\/files\/2013\/04\/image7.png\"><img loading=\"lazy\" decoding=\"async\" style=\"padding-left: 0px;padding-right: 0px;padding-top: 0px;border: 0px\" src=\"https:\/\/pitss.org\/files\/2013\/04\/image_thumb7.png\" alt=\"image\" width=\"667\" height=\"302\" border=\"0\" \/><\/a><\/p>\n<p>In the above screenshot, it shows first the name of the PITSS.CON user with the GROUP right below it. For example, the PITSS1 user is a member of the USERS group in PITSS.CON.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There is no easy way to determine which group a PITSS.CON user belongs to inside PITSS.CON. To find what group a PITSS.CON user belongs to, you can run the following SQL: Log into SQLPLUS (or SQL Developer, Toad) as the MIG user Run the following SQL: select mig_pitsscon_users.user_name,mig_pitsscon_groups.group_name from mig_pitsscon_users inner join mig_pitsscon_groups on mig_pitsscon_users.group_id=mig_pitsscon_groups.group_id; [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[6],"tags":[15,11,16,27,7],"class_list":["post-4130","post","type-post","status-publish","format-standard","hentry","category-pitss-con","tag-10g","tag-11g","tag-11gr2","tag-oracle-database","tag-pitss-con"],"_links":{"self":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/4130","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/comments?post=4130"}],"version-history":[{"count":3,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/4130\/revisions"}],"predecessor-version":[{"id":9096,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/4130\/revisions\/9096"}],"wp:attachment":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/media?parent=4130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/categories?post=4130"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/tags?post=4130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}