Database Users and Roles

This section describes the

You can grant users access to the database using the SaaS Web Console. All database users, whether created manually or by using the SaaS Web Console, are managed using Access control using SQL (DCL) to specify who is allowed to perform certain actions in the database.

This section describes the database users and roles. For more information about SaaS accounts and organizations, see Access Management.

The following SQL statements are the components of the DCL:

• CREATE USER: Creates a user.
• ALTER USER: Changes the password of a user.
• DROP USER: Deletes a user.
• CREATE ROLE: Creates a role.
• DROP ROLE: Deletes a role.
• GRANT: Gives roles, system privileges, and object privileges to users or roles.
• REVOKE: Withdraws roles, system privileges, and object privileges from users or roles.
• ALTER SCHEMA: Changes the owner of a schema (and all its schema objects) or sets schema quotas.