Re: Instructional Use of SQL*Menu and application security

In article <1992Apr16.180823.6331_at_oracle.us.oracle.com>, tiskanda_at_us.oracle.com (Thomas Iskan writes...
>In article <13APR199211065469_at_bestsd.sdsu.edu> mccurdy_at_bestsd.sdsu.edu (McCurdy M.) writes:
>> In SQL*Menu, I am told, there is no way to restrict access to
>>applications from other users. That is, in a multiple user
>>environment, each user has access to and may modify any other users
>>application. I am running VMS V. 5.4-2 and SQL*Menu.
>>
>> If any instructional users have comments or alternatives, it
>>would be good hearing about them.
>>
>>
>>Mike McCurdy
>>University Computing Services
>>San Diego State University
>>mccurdy_at_bestsd.sdsu.edu What? :()
>
>You are correct if you gave the sqlmenu user ADMINISTRATE priveleges.
>If you give them DESIGNER priveleges, then they won't be able to change
>other's apps.
>Please refer to p5-39 of menu doc. I seem to recall that there is an
>enhancement req. filed (not sure though, check w/ WWSupport)
>..

        I've been told by Oracle that all you need to access other applications within sql*menu is design privs. The instructor using sql*menu for her class tells me that the students were given only design privs and any of them can access the others applications.

        I have to be missing something here. With all the levels of security that Oracle has, something must be amiss here.

Mike McCurdy
University Computing Services
San Diego State University
mccurdy_at_bestsd.sdsu.edu What? :| :0 :| :0 Received on Mon Apr 20 1992 - 18:09:00 CEST