12-05-2017 09:27 AM
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?
12-09-2017 02:31 AM
12-05-2017 10:27 AM - edited 12-05-2017 10:28 AM
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).
12-05-2017 12:24 PM
Thank you Juans, Do you have any reference documents or examples for linux environment -sas internal account database configuration or access..
thanks in advance!!
12-06-2017 02:23 AM
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.
12-07-2017 03:48 AM
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.
12-07-2017 03:56 AM
SAS Token Authentication: http://documentation.sas.com/?docsetId=bisecag&docsetTarget=p06o3ymf2cuw16n1cmyi47t9icsn.htm&docsetV...
12-08-2017 05:56 PM
@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.
12-09-2017 02:31 AM
Need further help from the community? Please ask a new question.