Scalable Database Server, HiRDB Version 8 System Operation Guide

[Contents][Index][Back][Next]

24.4.4 Schema definition privilege setup

A DBA privilege holder uses the GRANT statement to grant the schema definition privilege to other users. The schema definition privilege cannot be granted to a role. When schema definition privilege is granted, that information is registered in SQL_USERS.

Example
Grant schema definition privilege and RDAREA usage privilege (RDAREA name is RDAREA01) to a user who creates tables (authorization identifier is USR02):
GRANT SCHEMA TO USR02
GRANT RDAREA RDAREA01 TO USR02