cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
Regina_Oliveira
Calcite | Level 5 Regina_Oliveira
Calcite | Level 5

Set Level Permission in relational database

Posted 05-17-2018 01:34 PM (800 views)

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.

0 Likes
Reply
1 REPLY 1
SASKiwi
PROC Star SASKiwi
PROC Star

Re: Set Level Permission in relational database

Posted 05-17-2018 08:17 PM (766 views)  |   In reply to Regina_Oliveira

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.

0 Likes
Reply

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.

Watch Get Started with SAS Information Catalog in SAS Viya on YouTube

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • ‎05-17-2018 01:34 PM
  • 801 views
  • 0 likes
  • 2 in conversation