Mysql esquemas de autorizacion

Solo disponible en BuenasTareas
  • Páginas : 5 (1097 palabras )
  • Descarga(s) : 0
  • Publicado : 20 de noviembre de 2010
Leer documento completo
Vista previa del texto

Identifies an SQL schema with a schema name, and consists of an authorization identifier that indicates the user or schema owner account, in addition to the descriptors for each element of the scheme. Schema elements include tables, constraints, views, domains and other components (such as grants authorization) that describe the schema

A schema is created using theCREATE SCHEMA, which can contain all the elements of the schema definitions. Alternatively, we can assign a name and a schema authorization identifier and define these items later.

In addition to the concept of schema, uses the term SQL2 catalog or data dictionary DD (named collection of schemas). A list always contains a special schema named INFORMATION_SCHEMA, which provides authorized userswith information on all elements of all descriptors schemes in the catalog. You can define integrity constraints among relations, such as referential integrity relations only if such schemes exist within the same catalog. In addition, layout of the catalog may share certain elements, such as domain definitions.

Types of Authorization for modification of the data schema:
Authorization indices 
Allows creation and deletion of indices
Resource consent
Enables the creation of new relations
Authorization alternation
Allows the addition or deletion of attributes of relations
Authorization for disposal
Allows deletion of relations


GRANT and REVOKE commands allow system administrator to create MySQL user accounts and permissions and remove themfrom the accounts.

the account information is stored in MySQL tables in the mysql database. This database and access control system is discussed extensively in that you can consult for more details.

If the grant tables have permissions records containing names of tables or databases with case and lower_case_table_names system variable is set, REVOKE can not be used to remove thepermissions. It is necessary to manipulate the grant tables directly.

Permits may be granted at several levels:
Global privileges apply to all databases on a given server. These privileges are stored in the user grant table. GRANT ALL ON *.* and REVOKE ALL ON *.* grant and remove only global privileges.

Database Level
The database permits apply to all objects in a given database.Theseprivileges are stored in tables and mysql.db.GRANT ALL ON db_name .* and REVOKE ALL ON db_name .* grant and remove permissions only databases.

Table level
Table privileges apply to all columns in a given table. These privileges are stored in the table mysql.tables_priv. GRANT ALL ON db_name.tbl_name and REVOKE ALL ON Quian db_name.tbl_name permissions granted and only table.Column level
Column permits apply to columns in a given table. These privileges are stored in the table mysql.columns_priv. Using REVOKE, you must specify the same columns that were granted permits.
Routine level
The CREATE ROUTINE, ALTER ROUTINE, EXECUTE, and GRANT apply to stored routines. May occur at the global and database. Also, except for CREATE ROUTINE, these privileges can begranted at the routine level for individual routines and are stored in the table mysql.procs_priv.


|Escrito por Administrator    |
|Sábado, 23 de Enero de 2010 07:13|
|Un esquema SQL se identifica con un nombre de esquema, y consta de un identificador de autorización que indica el usuario o la |
|cuenta propietaria del esquema, además de los descriptores de cada elemento del esquema. Los elementos del esquema comprenden |
|tablas, restricciones, vistas, dominios y otros integrantes (como concesiones de autorización) que describen...
tracking img