BookmarkSubscribeRSS Feed
Regina_Oliveira
Calcite | Level 5

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.
How to do?

Thanks so much in advance.

1 REPLY 1
SASKiwi
PROC Star

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.

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
  • 1 reply
  • 630 views
  • 0 likes
  • 2 in conversation