The Data Modeler only supports DDL (Data Definition Language...
CREATE, DROP, ALTER...). It does not support DML (Data
Manipulation Language... SELECT, INSERT, DELETE, UPDATE...)
or DCL (Data Control Language... GRANT, REVOKE).
And it only supports PL/SQL code that is within a trigger
or stored procedure and knows nothing about SQL Plus commands
such as PROMPT, HISTORY...
So yes, if you want to add these types of items, you would
need to modify the script generated from Rose.
Patrick Kennedy
Rational Support
-----Original Message-----
From: Neira Oquenes, Ricardo Miguel, SYNAPSIS
To: [EMAIL PROTECTED]
Sent: 2/6/2002 10:04 AM
Subject: (ROSE) DataModeler-Oracle
Hello Folks
When a data model is created inside an Schema and this one is assigned
to a
data base, for example Oracle.X. Then, when it is carried out the
Forward
Engineering, I open the script and I can see the structure of the
tablas,
its relationships and some other things, depending on what is defined in
the
data model.
Apparently in Rose I cannot define access permits to the tablas or
specific commands of SQL PLUS (for example). Then if I want to carry out
these operations I should take the script generated by rose and to take
it
to an application that I allow to define commands of security or of
manipulation of data.
For people that work with Oracle, how do you define the security
settings
(GRANT, REVOKE), or SQL PLUS specific commands (PROMPT, LIST HISTORY).
Of what way do you modify the script generated by rose with the commands
described above?.
thanks in advance.
Atte.
Ricardo Neira Oquenes.
* [EMAIL PROTECTED]
* (56) (02) 6321240 - Anexo 3256 � 3512
GI Arquitectura y Est�ndares
SYNAPSIS
Santiago, Chile.
************************************************************************
* Rose Forum is a public venue for ideas and discussions.
* For technical support, visit http://www.rational.com/support
*
* Post or Reply to: [EMAIL PROTECTED]
* Subscription Requests: [EMAIL PROTECTED]
* Archive of messages:
* http://www.rational.com/support/usergroups/rose/rose_forum.jsp
* Other Requests: [EMAIL PROTECTED]
*
* To unsubscribe from the list, please send email
* To: [EMAIL PROTECTED]
* Subject: <BLANK>
* Body: unsubscribe rose_forum
************************************************************************
*
************************************************************************
* Rose Forum is a public venue for ideas and discussions.
* For technical support, visit http://www.rational.com/support
*
* Post or Reply to: [EMAIL PROTECTED]
* Subscription Requests: [EMAIL PROTECTED]
* Archive of messages:
* http://www.rational.com/support/usergroups/rose/rose_forum.jsp
* Other Requests: [EMAIL PROTECTED]
*
* To unsubscribe from the list, please send email
* To: [EMAIL PROTECTED]
* Subject: <BLANK>
* Body: unsubscribe rose_forum
*************************************************************************
