SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
A-10
ALTER COLLATION Statement
ALTER COLLATION Statement
ALTER COLLATION is a DDL statement that renames a collation or alters security
attributes for a collation.
collation
is the name of the collation to alter (or an equivalent DEFINE). If SMF is installed
on your node, collation must be either a virtual name or a direct name.
RENAME new-name
specifies a new Guardian name (or an equivalent DEFINE) for the object. SQL
changes all references in the catalog to the new name.
OWNER or SECURE
specifies the owner and the security for the collation. For more information, see
OWNER FILE ATTRIBUTE on page O-10, Security on page S-11, or SECURE File
Attribute on page S-11.
Considerations—ALTER COLLATION

ALTER COLLATION requires read and write authority for the collation and the
catalog in which the collation is registered.
Only one DDL statement can operate on a given SQL object (or partition of an SQL
object) at a time. An error occurs if you attempt to run an ALTER COLLATION
statement while another process is executing a DDL operation on the same object.
The specific error depends on the DDL operation involved and the phase of the
operation at which the conflict occurs. For more information, see DDL (Data
Definition Language) Statements on page D-20.

Restricting access to a collation effectively restricts access to objects that use the
collation. This restriction is similar to restrictions for tables and views, but because
collations are used differently from tables and views, you might want to use less
restrictive security.
This scenario illustrates the type of problem that can occur if you alter the security
for a collation to make it more restrictive:
1. User A creates a collation available to user B.
2. User B creates a table that uses the collation.
3. User A alters the security of the collation such that user B can no longer
access it.
{| RENAME new-name |}
ALTER COLLATION collation {| OWNER group,user |}
{| SECURE "rwep" |}