USAGE privileges on a schema

fokimure

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?

VValdar

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.