Data Control Language
E36072
Data Control Language (DCL) is a subset of SQL used to define and manage access permissions and security controls on database objects.
Statements (50)
| Predicate | Object |
|---|---|
| instanceOf |
SQL sublanguage
ⓘ
database access control mechanism ⓘ |
| abbreviation | DCL ⓘ |
| aimsTo |
enforce database security policies
ⓘ
prevent unauthorized data access ⓘ |
| category |
access control
ⓘ
database security ⓘ |
| controls |
access to database roles
ⓘ
access to functions ⓘ access to schemas ⓘ access to sequences ⓘ access to stored procedures ⓘ access to tables ⓘ access to views ⓘ |
| defines |
privileges on database objects
ⓘ
role-based access control rules ⓘ user access rights ⓘ |
| governs |
who can DELETE data
ⓘ
who can INSERT data ⓘ who can SELECT data ⓘ who can UPDATE data ⓘ |
| hasCommand |
AUDIT
ⓘ
DENY ⓘ GRANT ⓘ NOAUDIT ⓘ REVOKE ⓘ |
| implementedBy |
IBM DB2
ⓘ
surface form:
IBM Db2
MariaDB ⓘ SQL Server ⓘ
surface form:
Microsoft SQL Server
MySQL ⓘ Oracle Database ⓘ PostgreSQL ⓘ SQLite ⓘ |
| partOf |
SQL
ⓘ
SQL ⓘ
surface form:
Structured Query Language
|
| relatedTo |
Data Definition Language
ⓘ
Data Manipulation Language ⓘ Transaction Control Language ⓘ |
| supportsConcept |
GRANT OPTION
ⓘ
object-level permissions ⓘ role management ⓘ schema-level permissions ⓘ system-level privileges ⓘ |
| usedBy |
database administrators
ⓘ
security administrators ⓘ |
| usedFor |
defining access permissions on database objects
ⓘ
granting privileges to users ⓘ managing security controls on database objects ⓘ revoking privileges from users ⓘ |
| usedIn | relational database management systems ⓘ |
Referenced by (1)
Full triples — surface form annotated when it differs from this entity's canonical label.