Message-Id: <10542.110720@fatcity.com> From: Veronica Levin Date: Wed, 28 Jun 2000 15:55:51 -0600 Subject: Roles in Oracle Forms Hi listers, Oracle 7.3.4, AIX 4.2.1, Forms 4.5 Forms developer asked me (DBA) to create a role for a specific user = with specific privileges. Done. Now, she wants to grant the role to the user using the forms security = menu, and the new role does not appear in the list of "available roles". I runned the frm45sec.sql to recreate the view FRM45_ENABLED_ROLES and = the new role is included there, but still can't see it through the menu. I have no idea of what is going on and don't know how to solve it..=20 Please help! Thanks in advance, Saludos, Ver=F3nica Levin Enr=EDquez Administrador AIX Compa=F1=EDa Cervecera de Nicaragua Tel=E9fono: 505-2493779 Fax: 505-2443979 Email: vlevin@victoria.com.ni=20 http://victoria.com.ni -----Mensaje original----- De: Jonathan Gennick [mailto:jonathan@gennick.com] Enviado el: Jueves 8 de Junio de 2000 3:30 PM Para: Multiple recipients of list ORACLE-L Asunto: Re: Help in sqlplus That's by design. The Windows versions of SQL*Plus do not display information from the help tables. All you get is that dialog referring you to the manuals. I don't really understand why Oracle felt they had to do that, but do it they did. Jonathan _____________________________________________________ jonathan@gennick.com =20 http://gennick.com Brighten the Corner Where You Are On Thu, 08 Jun 2000 10:44:00 -0800, you wrote: > I am running 8.05 on NT4 SP4. > > I have built the help tables, they are there, with the data but >whenever I do a help I get: > >SQL> help >SQL*Plus Help Files are included in Oracle Documentation. >You have to read SQL*Plus Help Files from Oracle Documentation --=20 Author: Jonathan Gennick INET: jonathan@gennick.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may