CA Datacom SQL Security › Implementing the SQL Security Model › Table-Level and View-Level Authorizations

Table-Level and View-Level Authorizations

At the table/view level, there are access rights named SELECT, DELETE, UPDATE, ALTER, and DELETE. These access rights refer to the authority to execute the corresponding SQL statement against that table or view. For instance, to execute a DELETE statement to delete a row from a table, that user must have the DELETE access right for that table. The ALTER access right applies only to tables.