Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

USAGE privileges on a schema

Does having USAGE on a schema allow any operations? It seems like it just allows users to know that the schema exists. If it's limited to simply knowing about the schema, is there a reason why everyone shouldn't have USAGE?

Answers

  • VValdarVValdar Employee
    edited October 2022

    Hi fokimure,

    That's a level of security, for example you can avoid showing all your staging schemas to end-users, or some end-users may not be allowed to see other end-users table (think multiple companies using the same database), there are tons of reason to not giving this privilege to everyone.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.