{"id":1010,"date":"2021-10-02T23:40:28","date_gmt":"2021-10-02T18:10:28","guid":{"rendered":"https:\/\/techieshouts.com\/home\/?p=1010"},"modified":"2022-08-09T19:03:19","modified_gmt":"2022-08-09T13:33:19","slug":"teradata-get-logged-in-user-details","status":"publish","type":"post","link":"https:\/\/techieshouts.com\/home\/teradata-get-logged-in-user-details\/","title":{"rendered":"Teradata get logged in user details easily"},"content":{"rendered":"\n<p><a href=\"https:\/\/en.wikipedia.org\/wiki\/Teradata\" target=\"_blank\" rel=\"noopener\">Teradata<\/a> has some great inbuilt functions to help to collect the basic details of the user. It has functions to identify who is the current logged in user, what is the role associated with the user in the system<\/p>\n\n\n\n<h2>Logged in user-id<\/h2>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"classic\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT CURRENT_USER;<\/pre>\n\n\n\n<p>The above command will give the ID of the currently logged in user<\/p>\n\n\n\n<h2>Current user&#8217;s role<\/h2>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"classic\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT ROLE;<\/pre>\n\n\n\n<p>The above command will give the role associated with the logged-in user<\/p>\n\n\n\n<h2>Current user&#8217;s profile<\/h2>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"classic\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT PROFILE;<\/pre>\n\n\n\n<p>The above command will give the Teradata profile of the user<\/p>\n\n\n\n<p>Also read,<\/p>\n\n\n\n<ol><li><a href=\"https:\/\/techieshouts.com\/home\/teradata-get-current-date-and-time\/\">Teradata get current date and time<\/a><\/li><li><a href=\"https:\/\/techieshouts.com\/home\/create-table-types-in-teradata-with-examples\/\">Creating tables with examples<\/a><\/li><li><a href=\"https:\/\/techieshouts.com\/home\/create-table-using-select-in-teradata\/\">Create tables using Select in Teradata<\/a><\/li><li><a href=\"https:\/\/techieshouts.com\/home\/using-bteq-export-table-to-file-in-teradata\/\">Teradata BTEQ to export table to file <\/a><\/li><\/ol>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Teradata has some great inbuilt functions to help to collect the basic details of the user. It has functions to identify who is the current logged in user, what is the role associated with the user in the system Logged in user-id The above command will give the ID of the currently logged in user\u2026 <span class=\"read-more\"><a href=\"https:\/\/techieshouts.com\/home\/teradata-get-logged-in-user-details\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[9],"tags":[170,167,172,171,169,168],"_links":{"self":[{"href":"https:\/\/techieshouts.com\/home\/wp-json\/wp\/v2\/posts\/1010"}],"collection":[{"href":"https:\/\/techieshouts.com\/home\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/techieshouts.com\/home\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/techieshouts.com\/home\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/techieshouts.com\/home\/wp-json\/wp\/v2\/comments?post=1010"}],"version-history":[{"count":2,"href":"https:\/\/techieshouts.com\/home\/wp-json\/wp\/v2\/posts\/1010\/revisions"}],"predecessor-version":[{"id":1060,"href":"https:\/\/techieshouts.com\/home\/wp-json\/wp\/v2\/posts\/1010\/revisions\/1060"}],"wp:attachment":[{"href":"https:\/\/techieshouts.com\/home\/wp-json\/wp\/v2\/media?parent=1010"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techieshouts.com\/home\/wp-json\/wp\/v2\/categories?post=1010"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techieshouts.com\/home\/wp-json\/wp\/v2\/tags?post=1010"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}