Database Users and Roles

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 page is only relevant for 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).