Snowsight - Databases: Access Control for ObjectsΒΆ

This topic describes how to manage access control for your database objects.

Use the Privileges section of your object details to view, grant, and revoke privileges on your database objects.

When you group grants by privilege, Snowsight indicates whether a privilege was inherited or directly granted.

Changing object privileges requires one of the following roles:

  • The owner of a database or database object. For example, the role with the OWNERSHIP privilege on the object.

  • A role with the global MANAGE GRANTS privilege.

Granting Privileges on ObjectsΒΆ

To grant privileges on database objects:

  1. Go to the Privileges section of a database object.

  2. In the upper-right corner of the Privileges section, select Privilege.

  3. Select the role you want to grant privileges to.

  4. Select the privilege you want to grant to the role.

  5. If you want the role to be able to grant the privilege to other roles, select Grant option.

  6. Repeat the steps for each privilege you want to grant to the role.

  7. Select Grant Privileges.

Revoking Privileges on ObjectsΒΆ

To revoke privileges on database objects:

  1. Go to the Privileges section of a database object.

  2. In the upper-right corner of the Privileges section, select Privilege.

  3. Remove the privileges that you want to revoke.

  4. Select Grant Privileges.