If a catalog is bound to a workspace, the users in that workspace who have privileges to catalog objects select, read files, write files, execute will be able to do so. you also need USE CATALOG and USE SCHEMA to list objects in that hierarchy to begin with. If you dont have grants on a catalog you wont even see it. If you do have access to a catalog and that catalog is not bound to the workspace you have logged into it will be greyed out and show as disabled.