how to restrict the users from setting up libraries and registering tables in DI studio.Currently every user is setting up libraries and tables. we end up with a lot of duplication.
we want to give permission to particular users.
Thanks in advance.
Look into the roles in SAS Management Console / User Manager. I expect there to be roles for SAS DI Studio.
There are some SAS client applications that do not implement roles and capabilities, DI Studio is one of them (as is Enterprise Miner). For these apps, it is generally the case that users leveraging these more advanced applications have the same functional role, such as "ETL Developer" in this case. I've implemented the concept of ETL Developers and Data Managers as two separate functional roles in the past. For our Data Managers, we gave them WriteMetadata, Write, Create, and Delete permissions to shared data folders within metadata for registering libraries and tables. Other users would just have ReadMetadata and Read permissions to these folders. In this way, you can control who has access to manage shared locations for libraries/tables, even if you cannot restrict an ETL Developer from defining a library via DI Studio.
I hope that helps.
There are some SAS client applications that do not implement roles and capabilities, DI Studio is one of them (as is Enterprise Miner).
IMO, that is a systemic bug, and should be fixed ASAP. ASAP meaning next Tuesday.
Consistency across the whole platform is essential for working with big software packages like SAS.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
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.