BookmarkSubscribeRSS Feed
Rhodochrosite | Level 12

What access rights configuration(s) needs to be set to allow a user to write from Data Integration Studio to an Oracle schema?



Opal | Level 21

Access rights for a particular Oracle account are set up by an Oracle DBA - talk to your DBA to get him/her to set up the update/delete/append rights that you need for the tables you want to write to. 

SAS Employee
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.

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 3 in conversation