https://communities.sas.com/t5/Administration-and-Deployment/Access-Rights-to-Write-to-Oracle-or-non-SAS-Table/m-p/561085#M16330 Are you asking about access rights inside Oracle?<BR />If so, see <a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/13976">@SASKiwi</a> comment.<BR /><BR />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. Thu, 23 May 2019 10:46:27 GMT SimonDawson 2019-05-23T10:46:27Z https://communities.sas.com/t5/Administration-and-Deployment/Access-Rights-to-Write-to-Oracle-or-non-SAS-Table/m-p/560924#M16327 <P>What access rights configuration(s) needs to be set to allow a user to write from Data Integration Studio to an Oracle schema?</P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 22 May 2019 18:17:39 GMT https://communities.sas.com/t5/Administration-and-Deployment/Access-Rights-to-Write-to-Oracle-or-non-SAS-Table/m-p/560924#M16327 DavidPhillips2 2019-05-22T18:17:39Z https://communities.sas.com/t5/Administration-and-Deployment/Access-Rights-to-Write-to-Oracle-or-non-SAS-Table/m-p/560973#M16328 <P>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.&nbsp;</P> Wed, 22 May 2019 20:43:43 GMT https://communities.sas.com/t5/Administration-and-Deployment/Access-Rights-to-Write-to-Oracle-or-non-SAS-Table/m-p/560973#M16328 SASKiwi 2019-05-22T20:43:43Z https://communities.sas.com/t5/Administration-and-Deployment/Access-Rights-to-Write-to-Oracle-or-non-SAS-Table/m-p/561085#M16330 Are you asking about access rights inside Oracle?<BR />If so, see <a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/13976">@SASKiwi</a> comment.<BR /><BR />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. Thu, 23 May 2019 10:46:27 GMT https://communities.sas.com/t5/Administration-and-Deployment/Access-Rights-to-Write-to-Oracle-or-non-SAS-Table/m-p/561085#M16330 SimonDawson 2019-05-23T10:46:27Z