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?
0
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Answers
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.