Tag Info

New answers tagged


The privilege on DATABASE only grants general connection rights to the database and no more. A user with just that privilege can only see what the general public is allowed to see. To grant read access to all tables, you also need privileges on all schemas and tables: GRANT USAGE ON SCHEMA public TO myuser; -- more schemas? GRANT SELECT ON ALL TABLES IN ...


By default DB2 delegates all authentication to the operating system of the server, so the "host" is always the same -- the DB2 server host and the authenticated user ID does have the "host" component and all privileges are verified against the user ID only. Depending on what you are actually trying to achieve, you may be able to restrict access to certain ...

Top 50 recent answers are included