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 UID
and PWD
supplied in the ODBC DSN, the user's local account is what ends up being used in the con
object:
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.