Thanks cynthia.. But what i was looking for was an option that would disable the user from selecting numbers or tables printed on an ods html. I was able to get some commands and implement it in template. It does work to some extent but is not foolproof.     proc template;       define style test;         parent=styles.normal;         style body from body /               prehtml="<div   style='-moz-user-select: none; -webkit-user-select: none; -ms-user-select:none; user-select:none;'   unselectable='on'   onselectstart='return false;'   oncontextmenu='return false;'   onmousedown='return false;' oncopy='return false;' oncut='return false;' onpaste='return false;' >";          style body from body /               posthtml="</div>";     end;     run; ods html file="/MYPATH/TEST.HTML" Style=test; proc report data=sashelp.class; run; ods html close; ... View more

Thanks Ben.. I too wanted to find something in the lines where oracle could somehow force a sas session.. However SASKIWI has given a workable solution which i would like to explore into.. ... View more

Sorry.. i meant to write access..wrote connect instead.. yes the event will get captured as a new row in a table with a datetime .. From the point you have mentioned , yes i can run a loop which could connect to the server at a regular interval or look at an option where a single connection will loop within itself.. But both these options will require SAS sessions to be kept live for a considerable amount of time.. That is the reason why i thought of asking this question... though logically i do understand that this is the only way.. Thanks... ... View more

Hi... This looks to be the metadata id of the user.. maybe you could have  a list of the metadata id of all your users in a permanent table... and then using the predefined stored process macros of _metauser you can probably identify the users meta-id and add the same to the link... I believe there is get metadata attr to get the details of the users.. but you would have to search more on this or wait for an expert to guide on this as i have never tried it out.. ... View more

Well I think you can also consider transient package for results.. but i do doubt the impact that the size of your overall results will have on your application. ... View more

Hi i dont think it is necessary to have preassigned libraries. you can always define a libref in your code with a libname statement and use the same. However it is always good to have preassigned libraries as shown by Tricia so that user restrictions/security are honoured by the stored process. ... View more

Hi.. why not divert the results to a permanent library .. Any restrictions ? Also have a look at creating sessions in stored process... they will be useful for your requirement ... View more

OS2Rules wrote: If they do, hopefully you have SAS/Connect.  Just establish a Connect session to both servers and act accordingly.  Hi Can you guide a bit more on how to use SAS/CONNECT for establishing a connection between two sas servers both of which have CONNECT.. i kind of have the same query... Thanks ... View more

Hi, I cannot test this right now... but can you check if something like this works &_URL?_program=/yourfolder/your+stored+process without mentioning a userid or password in your link... ... View more