CA Datacom SQL Security › Implementing the SQL Security Model › Adding View Security Authorizations › Access Rights Required

Access Rights Required

To create a view, you must possess the following access-right under resource class DTUTIL:

 cxx-name.SVCRE.sql-authid.sql-view-name

To drop a view, you need the following access-right under resource class DTUTIL:

 cxx-name.SVDRP.sql-authid.sql-view-name

To read or maintain the data defined by a view, you need the following access-rights under the same table-classes (for example, DXTABLE, DTTABLE) that you are using to secure other SQL resources such as tables.

 cxx-name.SV.sql-authid.sql-view-name

Each resource name is associated with four access-rights: ADD, READ, UPDATE, and DELETE. In concept, this is similar to the method used to grant access-rights to base tables.