Toad World® Forums

Grant access to all database objects

I am new to DB2 so forgive my ignorance, but I am looking for an easy way to apply security for a user to the whole database, similar to the db_datareader and db_datawriter roles in MS SQL Server. Oracle has select any table rights, is there anything like that in DB2?

If you are using DB2 on LUW (Linux, UNIX, Windows) you might consider granting DBADM authority to your user - that essentially gives him complete authority on that database:

GRANT DBADM WITH DATAACCESS WITH ACCESSCTRL ON DATABASE TO USER USER1;