About SQL Schemas
When you secure resource type DB, you control who can create an SQL schema. Until you secure resource type DB, any user can create an SQL schema.
How to Secure SQL Schemas
You secure SQL schemas by securing the DB resource.
Note: For more information, see Securing Databases.
If you secure SQL schemas externally, you must also include an entry in the SRTT with external security information for resource type QSCH.
How to Grant Definition Privileges on an SQL Schema
To allow a user to create an SQL schema, you issue a GRANT statement on the SQL schema resource type, specifying the privilege or privileges and identifying the SQL schema. You can specify any combination of CREATE, ALTER, DROP, and DISPLAY privileges, or you can specify all definition privileges (DEFINE).
As a holder of SYSADMIN or DBADMIN privilege, or as owner of the schema, you can specify WITH GRANT OPTION when you grant definition privileges to allow the recipient to grant the same privileges to another user.
More Information:
|
Copyright © 2014 CA.
All rights reserved.
|
|