SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
A-11
Examples—ALTER COLLATION
4. User B tries to compile SQL statements that reference user B's own table, but
the compilation fails because user B does not have authority to access the
collation.
Examples—ALTER COLLATION

This example renames a collation:
ALTER COLLATION ORDER1 RENAME ORDERA;

This example resecures a collation such that all users on the node can access it,
but only the generalized owner can write to or purge it:
ALTER COLLATION TRN31 SECURE "AOOO";
ALTER DEFINE Command
ALTER DEFINE is an SQLCI command that changes the attributes of DEFINEs in the
current SQLCI session. (ALTER DEFINE is similar to the TACL command ALTER
DEFINE.)
define
is the name of an existing DEFINE to alter.
** or =*
specifies all DEFINEs.
attr value
specifies an attribute and its value for the DEFINE.
If you specify the CLASS attribute, specify it first in the list of attributes. Setting the
CLASS attribute establishes a new set of attributes for the DEFINE and sets each
attribute associated with that CLASS to its initial value. If you specify CLASS after
ALTER DEFINE define-list { , attr value } ... ;
{ , RESET reset-list}
define-list is:
{ define }
{ ( define [ , define ] ... ) }
{ ** }
{ =* }
reset-list is:
{ attr }
{ ( attr [ , attr ]... ) }