SQL/MP Installation and Management Guide

ManualsBrandsHP ManualsServerHP NonStop G-Series

191

192

193

194

195

196

197

198

199

200

Adding, Altering, Removing, and Renaming

Database Objects

HP NonStop SQL/MP Installation and Management Guide—523353-004

7-15

Altering Catalog Attributes

Use the ALTER CATALOG statement to change the security of an entire set of catalog

tables. You can alter only the security specifications of a catalog. This statement does

not affect the system catalog CATALOGS table. You must alter that table with the

ALTER TABLE statement.

You cannot specify a security string for a catalog that does not include read access by

the owner of the catalog. Requiring that the catalog has read access by the owner

ensures that the owner of the catalog can subsequently read it.

The PROGRAMS, USAGES, and TRANSIDS tables of an SQL catalog and the

CATALOGS table of the system catalog can be secured separately from the remainder

of the catalog tables. To resecure these tables, you can use the ALTER TABLE

statement as described next under Altering Table Attributes on page 7-15.

This example alters the security of all the catalog tables of the catalog PERSNL:

>> ALTER CATALOG PERSNL SECURE "NNNO";

--- SQL operation complete.

To alter the security of a catalog, follow these steps:

1. Start an SQLCI session. Enter a LOG command to initiate a log file for the

statements and commands entered in this session. Keep the log for your records.

2. Determine the catalog name and existing security.

3. Enter the ALTER CATALOG statement.

For more information about defining catalog tables, see Creating Catalogs on

page 5-1.

Altering Table Attributes

To alter the security and physical file attributes of SQL tables, use the ALTER

statement. To alter the security attributes of tables, use the SECURE utility.

Altering a table's attributes or security specification neither invalidates any programs

nor affects dependencies of the table. If you alter the security of the table, however,

you might damage the security scheme of the dependent views and the access

Constraint New definition DROP CONSTRAINT

CREATE CONSTRAINT

Collation Security

Rename

ALTER COLLATION

SECURE

ALTER COLLATION RENAME

Comment Add/append/drop COMMENT

Object Operation Statement or Command (page 2 of 2)