05 May 2009

🛢DBMS: Data Control Language [DCL] (Definitions)

"The subset of SQL statements used to control permissions on database objects. Permissions are controlled using the GRANT and REVOKE statements." (Microsoft Corporation, "SQL Server 7.0 System Administration Training Kit", 1999)

"The subset of SQL statements used to control permissions on database objects. Permissions are controlled using the GRANT and REVOKE statements. See data definition language (DDL) and data manipulation language (DML)." (Microsoft Corporation, "Microsoft SQL Server 7.0 Data Warehouse Training Kit", 2000)

"A subset of Transact-SQL statements. DCL is used to control permissions on database objects." (Anthony Sequeira & Brian Alderman, "The SQL Server 2000 Book", 2003)

"A subset of Structured Query Language used to define data security, user function permissions, and data access to data in relational tables." (DAMA International, "The DAMA Dictionary of Data Management", 2011)

"SQL statements used for controlling access to data and data structures, e.g., GRANT and REVOKE." (Craig S Mullins, "Database Administration: The Complete Guide to DBA Practices and Procedures" 2nd Ed, 2012)

"The subset of SQL statements used to control permissions on database objects." (Microsoft, "SQL Server 2012 Glossary", 2012)

No comments:

Related Posts Plugin for WordPress, Blogger...

About Me

My photo
Koeln, NRW, Germany
IT Professional with more than 24 years experience in IT in the area of full life-cycle of Web/Desktop/Database Applications Development, Software Engineering, Consultancy, Data Management, Data Quality, Data Migrations, Reporting, ERP implementations & support, Team/Project/IT Management, etc.