Hello all well
I have a program in proc sql that collects information about user permissions. My question is is there a possibility to make changes to permissions using proc sql or do you have any specific proc command?
command made until now of collection would be this:
proc sql;
create table VA_Grupos as
select NOME_GRUPO, Login_Usuario, displayname, memDesc, title from
(select memid, name as NOME_GRUPO, memName as Login_Usuario, memDesc from dirm.Groupmempersons_info) as a left join
(select objid, title, displayname from dirm.person) as b on a.memid=b.objid
order by NOME_GRUPO, displayname;
quit;
proc sql;
create table VA_Usuarios as
select keyid, displayname, name, description,title from dirm.person
order by displayname;
quit;
Thanks