Home -> Usenet -> comp.databases.oracle -> Re: PL/SQL - does it do all sql statements???????

Re: PL/SQL - does it do all sql statements???????

From: Ruth Larson <rlarson_at_nswc-wo.nswc.navy.mil>
Date: Fri, 20 Aug 1993 16:32:42 GMT
Message-ID: <1993Aug20.163242.29888_at_relay.nswc.navy.mil> 








From Oracle V6 DBA Manual:



"Data Control Statements (DCL)  DCL statements are used to control two types
of access:  

	o	Access to the database (using, for example, GRANT CONNECT)
	o	Access to the database data (using, for example, GRANT
		SELECT or REVOKE DELETE).




DCL statements allow one user to let other users see, change, and use data
in his tables, and even to pass their privileges on to other users (GRANT
SELECT ... WITH GRANT OPTION).  Data control statements also include the
AUDIT statements.


        DCL and DDL statements are often categorized together. ..."



DCL = data control language


				Ruth Larson
				rlarson_at_nswc-wo.nswc.navy.mil


Received on Fri Aug 20 1993 - 18:32:42 CEST












Original text of this message