topic Re: SAS code to add users and groups to a group? in Administration and Deployment

SAS code to add users and groups to a group?

merrittr — Mon, 17 Aug 2015 17:39:08 GMT

I have a piece of code that lists all the objects (user or a group) that is a a member of another group

/*Connect to the metadata server. */

options metaserver="biserver.whatever.com"

metaport=8561

metauser="sasadm@saspw"

metapass="password"

metarepository="Foundation";

%mduextr(libref=work)

proc sql;

create table work.sasmembership as

select distinct name 'name' as name , memName 'memName' as memName,'GROUP'

from work.Groupmemgroups_info

where substr(name,1,1) in ('p','v','f','w') or name in ('Report Developer','sqlserver','Report Viewer')

UNION

select distinct name 'name' as name , memName 'memName' as memName,'USER'

from work.Groupmempersons_info

where substr(name,1,1) in ('p','v','f','w') or name in ('Report Developer','sqlserver','Report Viewer');

quit;

what i want now is to be able to go through that group and isue a metadata command to add the member (be it a group or user) to the group

on another server is there a proc metadata command to add a group or user to a group?

command bla addtogroup jeff destinationgroupname

command bla addtogroup group1 destinationgroup

Re: SAS code to add users and groups to a group?

LinusH — Wed, 19 Aug 2015 14:11:58 GMT

%mduimplb?

Re: SAS code to add users and groups to a group?

merrittr — Wed, 19 Aug 2015 14:17:35 GMT

that seems to add users and groups to METADATA but it doesn't add users to groups or groups to groups correct?

I have all my users added and all my groups added via %mduimplb now I need to populate the groups based on a query to an older server

that had all the users added to the groups manually. Is that doable?

Re: SAS code to add users and groups to a group?

DavidStern — Wed, 19 Aug 2015 14:32:19 GMT

Linus is right, so yes it is doable.

You can use the User Import Macros (of which %mduimplb is the one which does the loading of data from 'canonical' - i.e pre-defined format - tables into metadata), to make users and groups members of a group, even if you're not using it to add/update/delete any users or groups themselves. You will need to populate one of these canonical tables called grpmems, which has two columns: grpkeyid memkeyid. The first, grpkeyid is the ID for the group as it was loaded into metadata - the value depends on how the group was populated. The second column, memkeyid, can be a user keyid, or a group keyid. The User Import Macros are documented here, and the canonical tables illustrated here.

Re: SAS code to add users and groups to a group?

merrittr — Wed, 19 Aug 2015 19:05:21 GMT

Ah gotcha that makes sense thanks guys!