I need to make the dataset read only vs updatable based on the roles given to the logged in user in the SAS SMC. Can you please suggest with the options available.
Let the RDBMS or OS handle that. SAS cannot overrule those settings.
Just make sure that the user that logged in to SAS is the same user as running on the OS/RDBMS.
Using groupaccounts for those kind of access will require your sas system is the only way for accessing the OS and RDBMS. Any other way will make any auditability traceablity an useless argument with group accounts. As this kind of security compliancy is a very nasty topic for sas people you could have a big challenge.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.