Security
The security issue can be summarized as the need to control who can use what data and for what purpose. The SQL GRANT and REVOKE commands allow certain privileged users to choose who will be authorized to look at or change database information. In most SQL implementations, access and data modification permissions can be controlled on the levels of both tables and columns.
The privileged users who bestow these permissions are the owners of databases and database objects (tables and views). A user owns a database or one of its objects by virtue of having created it with one of the SQL CREATE commands; some systems allow ownership to be transferred from the creator to another user.
Most multiuser systems designate another privileged user, ...
Get Practical SQL Handbook, The: Using SQL Variants, Fourth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
