RShiny app connection to Cloudera ODBC Database with Kerberos Auth

shiny
, ,
1

Hello,

I have a Shiny app which runs locally and is getting data from a Cloudera database through ODBC connection and Kerberos Auth.
This is the code is use to connect to database:

con <- dbConnect(odbc::odbc(),
                   driver = "Cloudera ODBC Driver for Impala",
                   database = "default",
                   host = "example@example",
                   port = 21050,
                   SSL=1,
                   UseSystemTrustStore=1,
                   AuthMech=1)

I get connected to the database with my user profile from Active Directory (Kerberos ticket created and send automatically). However, with that user profile I dont have access to all tables of the database and I want to ask if there is a way to "select" the user profil which will make the connection to database.

For example, lets say that from AD automatically is used for the connection and Kerberos authentication, username1 but I want to make the connection to database with username2, even if username1 is the current profile on AD.

THank you in advance.

2

This topic was automatically closed 54 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.