BookmarkSubscribeRSS Feed
Filipvdr
Pyrite | Level 9

Hello all,

 

We have the following problem

 

We have a library for Domain A:

Dataset 1

Dataset 4

Dataset 5

 

for Domain B:

Dataset 2

 

for domain C:

dataset 3

We have a report "Dashboard" which uses

- Dataset 1 (Domain A)

- Dataset 2 (Domain B)

- Dataset 3 (Domain C)

 

This report is placed in a separate folder "Management Reports"

 

We want the "Management-user" to be able to see the report "Dashboard". He can create new reports on this datasets 1,2,3 but we don't want him to see/use datasets 4,5 in library A. 

 

We also don't want to load the data twice in a separate library for the Management Dashboard.

 

If we give the rights for the Management user to library A,B,C and he has designer rights. He can create new reports on datasets 4,5.

 

 

2 REPLIES 2
anja
SAS Employee

Hi,

 

a few questions:

 

Did you assign the permissions in VA or SAS Management Console, and, if the latter, did you assign

the permissions on the SAS Folders?

 

If a user is not allowed to access a data set, you would have to deny permissions on that data set,

for that user.

The problem with that is, if there are several users that have access to some of the data sets

in domain A, B and C, but not to others, it can become hard to administer this.

 

Would it maybe be possible to modify the domain A, B and C as such either the data sets the

users have access to are in one lib/folder, and the ones not accessable in another.

Or, would it maybe make sense to not have domains A, B and C and just one lib/folder, then

assigning permissions to the data sets?

It wouldnt be the best way as it is always recommended to assign permissions on the folders

rather than data sets. Yet in the described case where different folders and different data sets in

these folders are used, not sure that there is much you could do other than the permissions

on the lowest level (= tables).

 

Can you provide some more info on the data sets and folders and the users that need to have access to?

As mentioned above, I'd be curious about whether this is one situation for one certain user,

or, if this is a general set up.

 

Thanks

Anja

 

 

Filipvdr
Pyrite | Level 9

In Sas Management Console on folder level.

 

Is it not possible to arrange this with Designer and Viewer (SAS VA)?

If the user only has viewer rights for the dataset, he can only view reports and not create reports himself/herself.

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 

CLI in SAS Viya

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.

Discussion stats
  • 2 replies
  • 740 views
  • 0 likes
  • 2 in conversation