Snowsight - Databases: Procedure Details

When you select a procedure in the database object explorer, the procedure details page appears.

This section provides a brief overview of how to navigate and use the procedure details page.

Interface

Description

Basic function details

Basic details about your function are located at the top of the page.

More menu

The More menu, located in the upper-right corner of the page, lets you do the following:

  • Edit

    Edit the procedure name and comment.

  • Drop

    Drop the procedure.

  • Transfer Ownership

    Transfer ownership of the procedure to another role.

The procedure details page includes the following sections:

  • Details

  • Procedure definition

  • Privileges

The Details section provides additional information about your procedure, including:

  • The data type of the procedure result.

  • Whether your procedure is an aggregate function.

  • Whether your procedure is a secure function.

  • Whether your procedure is a table function.

  • The language used to build the procedure.

The Procedure definition section contains the SQL that was used to initialize the procedure.

Use the Privileges section to view, grant, and revoke privileges on the procedure.

Managing Access Control on Database Objects

This section 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 granted directly.

Changing object privileges requires one of the following roles:

  • The owner of a database or database object (i.e. 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.