https://communities.sas.com/t5/Administration-and-Deployment/Set-Level-Permission-in-relational-database/m-p/463071#M13170 <P>I need to ensure that the user accesses a library that is configured for a SQL database has the same permission that the user already has in the SQL SERVER environment.<BR />How to do?</P><P>Thanks so much in advance.</P> Thu, 17 May 2018 17:34:19 GMT Regina_Oliveira 2018-05-17T17:34:19Z https://communities.sas.com/t5/Administration-and-Deployment/Set-Level-Permission-in-relational-database/m-p/463071#M13170 <P>I need to ensure that the user accesses a library that is configured for a SQL database has the same permission that the user already has in the SQL SERVER environment.<BR />How to do?</P><P>Thanks so much in advance.</P> Thu, 17 May 2018 17:34:19 GMT https://communities.sas.com/t5/Administration-and-Deployment/Set-Level-Permission-in-relational-database/m-p/463071#M13170 Regina_Oliveira 2018-05-17T17:34:19Z https://communities.sas.com/t5/Administration-and-Deployment/Set-Level-Permission-in-relational-database/m-p/463196#M13174 <P>How do your users currently access SQL Server? If they use Windows Authentication - automatic authentication with their Windows account - then you can apply the same technique when accessing a SAS library accessing SQL Server.</P> Fri, 18 May 2018 00:17:06 GMT https://communities.sas.com/t5/Administration-and-Deployment/Set-Level-Permission-in-relational-database/m-p/463196#M13174 SASKiwi 2018-05-18T00:17:06Z