topic Re: Restrict-New library setup and new table regestery in SAS DI in Administration and Deployment

Restrict-New library setup and new table regestery in SAS DI

sathya66 — Wed, 04 Sep 2019 11:36:59 GMT

Hi all,

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.

Re: Restrict-New library setup and new table regestery in SAS DI

Kurt_Bremser — Wed, 04 Sep 2019 12:04:33 GMT

Look into the roles in SAS Management Console / User Manager. I expect there to be roles for SAS DI Studio.

Re: Restrict-New library setup and new table regestery in SAS DI

sathya66 — Wed, 04 Sep 2019 14:32:50 GMT

There is a role for library but I think ,it is for whether we can give plugin access(Data Library Manager) to the user or not through management console ?

Re: Restrict-New library setup and new table regestery in SAS DI

angieh — Wed, 04 Sep 2019 14:58:40 GMT

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.

- Angie

Re: Restrict-New library setup and new table regestery in SAS DI

sathya66 — Wed, 04 Sep 2019 16:08:37 GMT

Thanks for this and we are following one of these.

But some users are setting up LIBS and tables in their team/shared folders, that causing the duplication.

is there any other way we can control .

thanks,

Re: Restrict-New library setup and new table regestery in SAS DI

SASKiwi — Wed, 04 Sep 2019 23:15:29 GMT

What about not installing Management Console for those users? Do they need it for other reasons?

Re: Restrict-New library setup and new table regestery in SAS DI

sathya66 — Thu, 05 Sep 2019 07:16:50 GMT

Restricting SMC won't stop the users for setting up the libraries and tables from DI studio and also they need console for scheduling their jobs.

Re: Restrict-New library setup and new table regestery in SAS DI

Kurt_Bremser — Thu, 05 Sep 2019 07:29:20 GMT

@angieh wrote:

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.