Greg Rahn has posted comments on this change. Change subject: IMPALA-1659: Netezza compatibility functions: metadata ......................................................................
Patch Set 3: Looks correct per http://www.ibm.com/support/knowledgecenter/SSULQD_7.2.1/com.ibm.nz.adv.doc/c_advsec_masquerading.html nzsql -u JOHN -pw ABCD -db BIZ BIZ.SCM(JOHN)=> John uses the EXECUTE AS command to masquerade as the user Hank: BIZ.SCM(JOHN)=> EXECUTE AS HANK; EXECUTE AS To see which is the session user and which is the current user, run the following commands: BIZ(JOHN)=> SELECT session_user, current_user; SESSION_USER | CURRENT_USER --------------+-------------- JOHN | HANK (1 row) To reverse the EXECUTE AS command, use the REVERT command, which changes the current user back: BIZ(JOHN)=> REVERT; REVERT BIZ(JOHN)=> SELECT session_user, current_user; SESSION_USER | CURRENT_USER --------------+-------------- JOHN | JOHN (1 row) -- To view, visit http://gerrit.cloudera.org:8080/4063 To unsubscribe, visit http://gerrit.cloudera.org:8080/settings Gerrit-MessageType: comment Gerrit-Change-Id: I9b5d1009bbf42acc175a942d2df484e1c64822ca Gerrit-PatchSet: 3 Gerrit-Project: Impala-ASF Gerrit-Branch: master Gerrit-Owner: Zoltan Ivanfi <[email protected]> Gerrit-Reviewer: Greg Rahn <[email protected]> Gerrit-Reviewer: Marcel Kornacker <[email protected]> Gerrit-Reviewer: Tim Armstrong <[email protected]> Gerrit-Reviewer: Zoltan Ivanfi <[email protected]> Gerrit-HasComments: No
