Alter permission VA program

lgsucupira — Wed, 16 Dec 2020 12:16:11 GMT

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

Re: Alter permission VA program

ChrisNZ — Thu, 17 Dec 2020 01:15:20 GMT

What exactly are you trying to alter?

topic Alter permission VA program in SAS Programming

Alter permission VA program

Re: Alter permission VA program