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?
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).
Thank you Juans, Do you have any reference documents or examples for linux environment -sas internal account database configuration or access..
thanks in advance!!
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.
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.
SAS Token Authentication: http://documentation.sas.com/?docsetId=bisecag&docsetTarget=p06o3ymf2cuw16n1cmyi47t9icsn.htm&docsetV...
@vallsas - there are two basic ways to access Oracle:
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.