Are you asking about access rights inside Oracle? If so, see @SASKiwi comment. If you are interested in what needs to be configured inside SAS then you'd need to take a look through the SAS manuals to read up about outbound authentication to get your SAS users access to some Oracle credentials then look into the security administration guide to check how to give SAS users access to Oracle tables registered in SAS Metadata. ... View more

This is something to raise with SAS technical support. ... View more

Personally I found the Optimizing SAS on Red Hat Enterprise Linux particularly interesting. https://access.redhat.com/articles/1593123 Also the book from Brendan Gregg "Systems Performance: Enterprise and the Cloud". I enjoyed that too. ... View more

@woo there are a few things to think about there. Your post hasn't provided much in the way of specific details so I don't think you'll get many specific suggestions. A system/storage administrator at your site is probably going to be better placed to work with you to understand the workload the current SAS environment puts on the storage and suggest a path forward that will optimally provide more space. Generally speaking the more spindles you can get to back a file system the higher IOPS and throughput you'll get. If your solution to adding more space involves adding more drives then adding them to the same file system would see the throughput increase. If you combined the new spindles to make a new file system you'd likely have two slightly slower file systems. Like I mentioned up the top this is very generic advice since you don't have specifics about the situation there. Hopefully one of your storage appliance admins can work with you to optimize the configuration you go for to suite the workload. ... View more

@kkalam can you please provide a few more details about the situations. Do you mean the user is told the username or password is include at the credentials prompt or do they successfully access the SAS Studio application but their session which executes their SAS code gives some error? In a default deployment of SAS 9 based platform which includes the SAS Studio web applications user authentication requests are performed by the SAS Metadata Server. What is in the SAS Metadata Server log at the time the user attempt to authenticate? Can any user login? What happens if that user attempt to login with another SAS client like SAS Enterprise Guide? ... View more

It will be good to review the complete log. Can you please attach the complete file @kkalam? ... View more

This is almost certainly caused by a missing dependency. My money is on the numactl package not installed. `rpm -q numactl` if its missing `yum -y install numactl` then try install again. ... View more

There 0.72 gb in the /tmp folder which mihght be the issue. How can I change the /tmp folder to another location? See Installation Note 35525: Controlling the use of the /tmp directory space in SAS® 9.2 or later ... View more

Great write up @StuartRogers! Thanks. ... View more

If you can logon to a shell on that host you can do it. ssh-keygen(1) is the command to create the keys. Once created you'll need to put them onto the host you are logging onto into the users authorized_keys files. For details on SSH see the upstream manual provide by the OpenBSD project at https://man.openbsd.org/ssh-keygen.1 ... View more

@alexal and @blaszkam it would be possible if you install a SASFoundation per SAS/SHARE server you run. You can individually tweak the sasauth.conf per SAS/SHARE server that way. That would probably be too much administration overhead to do in practice though.   @blaszkam what is the use case you have here for needing multiple sasauth.conf configurations?   EDIT: Thought of another method that uses even more duct tape. The sasauth processes parses the configuration file on startup only. You can rotate around the different configuration files as you boot each SAS/SHARE instance up with sasauth.conf pointed at a different configuration. ... View more