[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== Security for System Editor  (OpenInsight Specific) ====
=== At 19 JUN 1998 05:37:32PM Jim Wheeler wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
I would like to keep certain users from opening the System Editor.

I tried changing the access permissions for it in the Database Manager; User Managment, but it had no effect.

Can anybody point me in the right direction?



Also, does anybody know which system table holds the User Name and Access Level. I know that I can retrieve the info using List_Users, but that can only be run from the command line, and resetting the RECEIVER still only gets me the User names.
</QUOTE>
----

=== At 22 JUN 1998 11:09AM John Duquette wrote:  ===

<QUOTE>[i]I tried changing the access permissions for it in the Database Manager; User Managment, but it had no effect.  Can anybody point me in the right direction?[/i]



If you set your users security to "USER" they should only be able to access OI in runtime mode and I believe the system editor is disabled.



If they are clicking on the OpenInsight on the task bar you can hide OI with the following code that Don Bakke posted:



Declare function FindWindow, ShowWindow



hWnd1%=FindWindow("RTI_OINSIGHT":\00\, "")

hWnd2%=FindWindow("AREV":\00\, "")

hWnd3%=FindWindow("PROGMAN":\00\, "")

rv=ShowWindow(hWnd1%, 0)

rv=ShowWindow(hWnd2%, 0)

rv=ShowWindow(hWnd3%, 2)



[i]Also, does anybody know which system table holds the User Name and Access Level. I know that I can retrieve the info using List_Users, but that can only be run from the command line, and resetting the RECEIVER still only gets me the User names.[/i]



All the user information is stored in the SYSENV table (encrypted).  If you want to retrieve all the data from the List_Users routine you should add the following line to your code:



call set_rowdef(\010101\) /* use a 01 for each column of data that is to be displayed */



John Revelation

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=CC35CF1B6E9D9ECE852566280076CB4C|View this thread on the  forum...]]