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.
A role is a classification or work task that the DBA assigns, such as payroll. Assignment of roles makes management of privileges convenient.
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 ]