DOCUMENTATION
/
Get started
Guides
Developer
Reference
Release notes
Tutorials
Status
  1. Overview
    • Snowflake Horizon Catalog
    • Applications and tools for connecting to Snowflake
        1. User interfaces
        2. Snowsight
            1. Exploring Snowsight
              • Working in the Snowsight user interface
                  1. Cookies in the web interface
                    • Snowsight navigation menu
                      • About the Snowsight Upgrade
                        • Upgrading to Snowsight
                          • Search Snowflake objects and resources
                            • Make database objects discoverable in Universal Search
                              • Manage your user profile
                                • Manage notification contacts
                                  • Manage support cases
                                    • Snowsight Templates
                                  • Notebooks
                                  • Workspaces
                                    • Worksheets
                                    • Managing integrations
                                      • Snowflake Copilot
                                      • Dashboards
                                        • Explore and manage data
                                      • Classic Console
                                      • Command-line clients
                                      • Snowflake CLI
                                        • SnowSQL
                                        • Extensions for code editors
                                        • Visual Studio Code SQL extension
                                          • Infrastructure as code
                                          • Snowflake Terraform provider
                                            • Drivers and libraries
                                            • API reference
                                              • Downloads and configuration
                                              • Download clients, drivers, and libraries
                                                • Configure clients, drivers, libraries, and applications to connect to Snowflake
                                                • Troubleshoot Snowflake client connectivity
                                                • Additional information about clients
                                                  1. View the client version used in a query
                                                    • Limits on query text size
                                                      • SQL statements supported for preparation
                                                      • Third-party software
                                                      • Ecosystem
                                                  2. Virtual warehouses
                                                  3. Databases, Tables, & Views
                                                  4. Data types
                                                    • Data Integration
                                                      1. Snowflake Openflow
                                                      2. Apache Iceberg™
                                                        1. Apache Iceberg™ Tables
                                                        2. Snowflake Open Catalog
                                                    • Data Engineering
                                                      1. Data Loading
                                                      2. Dynamic Tables
                                                      3. Streams and Tasks
                                                      4. dbt Projects on Snowflake
                                                      5. Data Unloading
                                                    • Migrations
                                                    • Queries
                                                    • Listings
                                                    • Collaboration
                                                    • Snowflake AI & ML
                                                    • Alerts & Notifications
                                                    • Security
                                                    • Data Governance
                                                    • Privacy
                                                    • Organizations & Accounts
                                                    • Business continuity & data recovery
                                                    • Performance Optimization
                                                    • Cost & Billing
                                                    GuidesApplications and tools for connecting to SnowflakeSnowsightWorking in the Snowsight user interfaceMake database objects discoverable in Universal Search

                                                    Make database objects discoverable in Universal Search¶

                                                    Snowflake logo in black (no text) Preview Feature — Open

                                                    Available to all accounts.

                                                    Universal Search helps you discover database objects in the account. By default, you can only discover objects to which you have already been granted access. Even if you have access to multiple accounts within your Snowflake organization, you aren’t able to see objects outside of the account you’re signed into because access grants do not cross accounts.

                                                    Administrators can enable users to discover objects to which they don’t yet have access, including objects in other accounts within your Snowflake organization, by managing object visibility.

                                                    Note

                                                    You can associate objects with contact information so that if a user performs a search and doesn’t have the privilege to access an object, they can select Request Access to see contact information.

                                                    OBJECT_VISIBILITY property¶

                                                    The OBJECT_VISIBILITY property controls the discoverability of objects in the account, enabling users without explicit access privileges to find objects and request access. Expanding visibility of objects in the account can simplify collaboration and streamline access requests.

                                                    OBJECT_VISIBILITY can be set on an account, database, or schema and follows Snowflake’s inheritance model: settings at a higher level (for example, accounts) automatically apply to lower levels (for example, databases) unless overridden.

                                                    You can set OBJECT_VISIBILITY to one of the following values:

                                                    • A YAML specification describing the visibility in one of the following formats:

                                                      $$
                                                      organization_targets:
                                                        - all_accounts_including_external
                                                      $$
                                                      
                                                      Copy

                                                      Or

                                                      $$
                                                      organization_targets:
                                                        - account: <account_name_1>
                                                        - account: <account_name_2>
                                                        - ...
                                                        - organization_user_group: <org_user_group_1>
                                                        - organization_user_group: <org_user_group_2>
                                                      $$
                                                      
                                                      Copy

                                                      In the syntax above:

                                                      • all_accounts_including_external: Specifies that all users in all accounts in the organization can see the object. This includes all accounts within the organization, even those to which external parties may have been given access, such as reader accounts.

                                                      • account: account_name: Specifies that all users in the specified account can see the object. You can specify multiple accounts. Note that account is the account name, not the account locator. You must specify only the account name, excluding the organization name.09-22

                                                      • organization_user_group: org_user_group: Specifies that the specified organization user group can see the object in all accounts in the organization where the organization user group has been imported.

                                                    • PRIVILEGED: Specifies that only roles within the current account that are granted an explicit privilege on the object can see the object. This is the default behavior in Snowflake.

                                                    You can revert an object to PRIVILEGED visibility at any time.

                                                    For specific syntax, usage notes, and examples, see the following topics:

                                                    CREATE commands¶

                                                    • CREATE DATABASE

                                                    • CREATE SCHEMA

                                                    ALTER commands¶

                                                    • ALTER ACCOUNT

                                                    • ALTER DATABASE

                                                    • ALTER SCHEMA

                                                    Access control requirements¶

                                                    Roles using this property must have the following privileges at a minimum:

                                                    Privilege

                                                    Object

                                                    Notes

                                                    MANAGE VISIBILITY

                                                    Account

                                                    Only the SECURITYADMIN role has this privilege by default. The privilege can be granted to additional roles as needed.

                                                    OWNERSHIP

                                                    Database or schema

                                                    Required to execute an ALTER DATABASE or ALTER SCHEMA statement to set object visibility. OWNERSHIP is a special privilege on an object that is automatically granted to the role that created the object, but can also be transferred using the GRANT OWNERSHIP command to a different role by the owning role (or any role with the MANAGE GRANTS privilege).

                                                    For instructions on creating a custom role with a specified set of privileges, see Creating custom roles.

                                                    For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.

                                                    Examples¶

                                                    Making a database broadly visible¶

                                                    The following statement makes the product_analytics database visible to all users in the current account (ACME_ENGINEERING):

                                                    ALTER DATABASE product_analytics
                                                    SET OBJECT_VISIBILITY =
                                                    $$
                                                    organization_targets:
                                                      - account: acme_engineering
                                                    $$;
                                                    
                                                    Copy

                                                    The following statement makes the database visible to all users in two additional accounts within the organization (ACME_MARKETING and ACME_SALES):

                                                    ALTER DATABASE product_analytics
                                                    SET OBJECT_VISIBILITY =
                                                    $$
                                                    organization_targets:
                                                      - account: acme_engineering
                                                      - account: acme_marketing
                                                      - account: acme_sales
                                                    $$;
                                                    
                                                    Copy

                                                    The following statement makes the database visible to all users in all accounts within the ACME organization:

                                                    ALTER DATABASE product_analytics
                                                    SET OBJECT_VISIBILITY =
                                                    $$
                                                    organization_targets:
                                                      - all_accounts_including_external
                                                    $$;
                                                    
                                                    Copy

                                                    Making a database visible to specific organization user groups¶

                                                    The following statement makes the database visible to specific organization user groups in all accounts within the ACME organization where the organization user group has been imported:

                                                    ALTER DATABASE product_analytics
                                                    SET OBJECT_VISIBILITY =
                                                    $$
                                                    organization_targets:
                                                      - organization_user_group: engineering
                                                      - organization_user_group: marketing
                                                      - organization_user_group: sales
                                                    $$;
                                                    
                                                    Copy

                                                    Limitations¶

                                                    • Objects that are discoverable and not accessible are only displayed in Universal Search. They are not visible in the database object explorer or SQL commands that show metadata (SHOW commands, etc.).

                                                    • For a schema, you can set the OBJECT_VISIBILITY property to PRIVILEGED to override any broader visibility settings that may be inherited from the account or database level, ensuring the schema remains accessible only by the owner.

                                                    • The OBJECT_VISIBILITY property cannot be set or overridden below the schema level. At the schema level, users can either see all objects or none.

                                                    • Search can take a few hours to reflect changes to object visibility.

                                                    Was this page helpful?

                                                    Visit Snowflake
                                                    Join the conversation
                                                    Develop with Snowflake
                                                    Share your feedback
                                                    Read the latest on our blog
                                                    Get your own certification
                                                    Privacy NoticeSite TermsCookies Settings© 2025 Snowflake, Inc. All Rights Reserved.
                                                    1. OBJECT_VISIBILITY property
                                                    2. Access control requirements
                                                    3. Examples
                                                    4. Limitations
                                                    Language: English
                                                    • English
                                                    • Français
                                                    • Deutsch
                                                    • 日本語
                                                    • 한국어
                                                    • Português