My company is implementing RStudio Server Open in order to centralize our data science.
We trying to create a centralized account that would be set up as an ODBC connection for various users to access as they develop. This would allow users to easily develop without worrying about what database permissions they would need.
We set up this account as an ODBC connection:
[Data_Source_Name] Driver=path/to/the/driver (downloaded from https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver15) Server=Server_Name UID=Centralized_User_Name PWD=Centralized_User_Password Database=The_Database Language=us_english Integrated_Security=True Trusted_Connection=Yes
We are able to successfully connect using this ODBC
Data_Source_Name, but instead of using the
PWD supplied in the ODBC DSN, the user's local account is what ends up being used in the
con <- DBI::dbConnect(odbc::odbc(), "Data_Source_Name") dbGetQuery(con, "SELECT SYSTEM_USER") > DOMAIN\\Local_User dbGetQuery(con, "SELECT CURRENT_USER") > DOMAIN\\Local_User
Why are the
SELECT SYSTEM_USER and
SELECT CURRENT_USER not returning
DOMAIN\\Centralized_User_Name? We are using Kerberos authentication. Are there any extra driver arguments that need to be declared?
If this is not a best practice, I am also open to exploring other methodologies. If users could provide documentation and examples, that would be appreciated.