Aster Databases and Privileges - Teradata Studio

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-10
dita:mapPath
pfg1542649412202.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities

To create an Aster database, you must be a superuser or granted the db_admin privilege.

When you create a database, you are the database owner. No other users can use it unless you grant them the privilege to use it. As the owner, only you can drop the database.
If your DBA has granted ALL privileges on schema PUBLIC to users in the PUBLIC role (default), users can by default create databases in any new databases you create, such as tables in the PUBLIC schema in the new database. Creating one or more schemas in the database and granting or denying appropriate privileges for users on those schemas can prevent this.
Use the following GRANT/DENY Users privileges for the databases you create.
Grant or Deny Privilege Admin Action
Grant access to the new database Grant at minimum the CONNECT privilege on the database to users or roles.
Grant ability to create schemas in the new database Grant users at minimum the CREATE privilege on the database.
Grant ability to create tables in the new database Grant users at minimum the CREATE privilege on one of the schemas in the database.
Deny users the ability to create tables or objects in a database Revoke the CREATE privilege on a database or schema for the user.