A resource owner can use SQL statements to grant access rights to others for the tables, views, columns, or plans controlled by the resource owner. The access rights applicable to tables and views are SELECT, INSERT, UPDATE, DELETE, and ALTER. The only access right applicable to columns is UPDATE. A table, view, or column owner may also allow other users to grant any access they may have on that resource to other users. To permit another individual to grant access to other users, the resource owner must specify the WITH GRANT option when issuing the SQL GRANT statement authorizing that individual access rights.
For SQL plans, the resource owner can grant either "execute" or "bind" authority for a specific plan.
The access rights required to process each SQL statement are listed on SQL Statements and SQL Security Access Rights. The rights required to process each CA Datacom/DB command are listed on CA Datacom/DB Commands and SQL Security Access Rights.
|
Copyright © 2014 CA.
All rights reserved.
|
|