Architecting, installing and maintaining your SAS environment

Set Level Permission in relational database

Reply
Occasional Contributor
Posts: 5

Set Level Permission in relational database

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.

Super User
Posts: 3,853

Re: Set Level Permission in relational database

Posted 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.

Ask a Question
Discussion stats
  • 1 reply
  • 124 views
  • 0 likes
  • 2 in conversation