In this chapter, we'll describe <AuthorizationID>s in detail, and show you the syntax to use to create, alter and destroy them.
-
AuthorizationID
We use the non-standard term <AuthorizationID> to mean a named bundle of Pr... -
CREATE ROLE statement
The CREATE ROLE statement defines new Role. The required syntax for the CRE... -
Privilege
An SQL Privilege allows an <AuthorizationID> to perform a given action on a... -
GRANT statement
The GRANT statement defines both Privilege grants and Role authorizations a... -
Data Control
You need explicit permission to perform any action on any SQL Object. SQL's... -
REVOKE statement
By the time we finish setting up a Catalog and granting appropriate Privile... -
DROP ROLE statement
The DROP ROLE statement destroys a Role. The required syntax for the DROP R... -
What Privileges do I Have?
Earlier in this chapter, we said that every Privilege is defined by a descr... -
Violating the Security System
Each of the following depends on a "hole" in the Standard SQL security wall... -
User functions
The SQL Standard defines four types of <AuthorizationID> whose values can b... -
Dialects
Many vendors have added their own Privileges to the SQL Standard's set. For...
