Home | Previous Page | Next Page   Managing Databases > Granting and Limiting Access to Your Database >

Granting Privileges

The authorization to use a database is called a privilege. For example, the authorization to use a database is called the Connect privilege, and the authorization to insert a row into a table is called the Insert privilege. Use the GRANT statement to grant privileges on a database, table, view, or procedure, or to grant a role to a user or another role. Use the REVOKE statement to revoke privileges on a database, table, view, or procedure, or to revoke a role from a user or another role.

Dynamic Server

A role is a classification or work task that the DBA assigns, such as payroll. Assignment of roles makes management of privileges convenient.

End of Dynamic Server

The following groups of privileges control the actions a user can perform on data:

For the syntax of the GRANT and REVOKE statements, see the IBM Informix: Guide to SQL Syntax.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]