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.