gazzag wrote:
> I was hoping to let this lie, but you can't help yourself, can you?
>
>>From the Oracle documentation:
>
> ------------------------------------------------------------------------------------
> Data Definition Language Statements
> Data definition language (DDL) statements define, alter the structure
> of, and drop schema objects. DDL statements enable you to:
>
> Create, alter, and drop schema objects and other database structures,
> including the database itself and database users (CREATE, ALTER, DROP)
>
> Change the names of schema objects (RENAME)
>
> Delete all the data in schema objects without removing the objects'
> structure (TRUNCATE)
>
> Grant and revoke privileges and roles (GRANT, REVOKE)
>
> Turn auditing options on and off (AUDIT, NOAUDIT)
>
> Add a comment to the data dictionary (COMMENT)
>
> DDL statements implicitly commit the preceding and start a new
> transaction. Some examples of DDL statements are:
>
> CREATE TABLE plants
> (COMMON_NAME VARCHAR2 (15), LATIN_NAME VARCHAR2 (40));
>
> DROP TABLE plants;
>
> GRANT SELECT ON employees TO scott;
>
> REVOKE DELETE ON employees FROM scott;
>
> ------------------------------------------------------------------------------------
>
>
> Not "metadata". Period.
>
> Or by "we" do you mean Sybrand and yourself?
GRANT and REVOKE are DCL ... not DDL. ;-)
http://www.udel.edu/evelyn/SQL-Class1/SQLclass3.html
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Sep 15 2005 - 11:15:26 CDT