Desktop productivity for business analysts and programmers

SAS Internal account can access database tables through E.G

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 88
Accepted Solution

SAS Internal account can access database tables through E.G

Hello All,

 

I have created a sas internal account in smc and assigned the groups of database user and other permissoins in smc. but when i try to open the server and libraries in E.G again it is asking password and user. when i try to give the internal account user and password the tables are appearing.

if I enter the OS user (user created on operating system and assigned the permissions in SMC) then as usual all the libraries and tables are accessible . 

my question is : sas internal users cant access database table through E.G?

 

 


Accepted Solutions
Solution
‎12-09-2017 10:33 AM
Super User
Posts: 5,919

Re: SAS Internal account can access database tables through E.G

@vallsas about your confusion about is account: you are not prompted for that because you are trying to access Oracle, it's because you need a SAS session first to even be able to access Oracle. And that session usually uses an OS account.
Data never sleeps

View solution in original post


All Replies
Trusted Advisor
Posts: 1,852

Re: SAS Internal account can access database tables through E.G

[ Edited ]

Hello @vallsas,

 

as far as I know, you do need an OS account. Simple: with EG, SAS is creating a Workspace Server session, which means, an OS process (sas.exe, on your name), hence the requirement of the OS account.


This is because by default, the Workspace Server is configured with Host Authentication.

 

There is an exception, though, which could be a bit technical, but it might be useful to you: If the workspace server would be configured with SAS token Authentication (such as the Stored Process server), then all your Workspace server sessions would run on the OS level with a single OS account, and then, you can set internal SAS accounts to run Workspace Server sessions.

 

I normally do not set SAS Token Authentication on Workspace server on Windows' SAS deployments, but it is a quite common practice on Linux deployments (as long as you are aware of the impact on Security on the fact every SAS session would run with a single OS account on the OS level).

Frequent Contributor
Posts: 88

Re: SAS Internal account can access database tables through E.G

Posted in reply to JuanS_OCS

Thank you Juans, Do you have any reference documents or examples for linux environment -sas internal account database configuration or access..

 

thanks in advance!!

Super User
Posts: 4,026

Re: SAS Internal account can access database tables through E.G

What database are you accessing and what accounts do you use? Do you use an OS account or an account that is only defined in the database? Until you provide more information we can't help you easily.

 

Also as @JuanS_OCS has already stated, please understand that SAS internal accounts cannot be used to directly connect to an external database as that database has no knowledge of them. 

Frequent Contributor
Posts: 88

Re: SAS Internal account can access database tables through E.G

I am using oracle database but you are asking do you use an OS account? i already mentioned i want to access oracle database by sas internal account.

i understand @JuanS_OCS message as mentioned there is a possibility thats why i asked the if any references.. 

 

After my own investigation its not possible to access database tables by sas internal account. its clear if you still see any possibility. please post otherwise thanks for the reply.

 

 

Trusted Advisor
Posts: 1,852

Re: SAS Internal account can access database tables through E.G

Super User
Posts: 4,026

Re: SAS Internal account can access database tables through E.G

@vallsas - there are two basic ways to access Oracle:

 

  1. Using a user account only defined in Oracle
  2. Using an OS user account that Oracle authenticates with the OS to confirm it is valid

 

SAS internal accounts can only be used with SAS token authentication as explained by @JuanS_OCS. Even with this approach you will still need a single user account only defined in Oracle (probably set up by your Oracle DBA) to be shared by all SAS users - see 1 above.

In other words SAS internal accounts by themselves will not work with Oracle, you also need an Oracle account to act as the token.

Solution
‎12-09-2017 10:33 AM
Super User
Posts: 5,919

Re: SAS Internal account can access database tables through E.G

@vallsas about your confusion about is account: you are not prompted for that because you are trying to access Oracle, it's because you need a SAS session first to even be able to access Oracle. And that session usually uses an OS account.
Data never sleeps
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 7 replies
  • 318 views
  • 4 likes
  • 4 in conversation