BookmarkSubscribeRSS Feed
DavidPhillips2
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?

 

 

2 REPLIES 2
SASKiwi
PROC Star

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. 

SimonDawson
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 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 680 views
  • 2 likes
  • 3 in conversation