To issue a CREATE TABLE statement, a user must have either the CATALOG access right or Ownership status for the database to which the new table belongs. If the user does not specify an IN AREA clause with the CREATE TABLE statement, the table is created in the default area specified at Multi-User startup and the user must have CATALOG access for the database containing this area.
Note: For more information, see the Multi-User startup option SQLDEFAULT in the CA Datacom/DB Database and System Administration Guide.
With external security, the owner of a database is a user with access to the special system.DB00nnn.999.CATALOG resource in the DTUTIL resource class. For more information, see DBUTLTY and External Security.
|
Copyright © 2014 CA.
All rights reserved.
|
|