Wednesday, 16 March 2016

Granting DATAACCESS authority with DBADM authority to user in DB2

By using the following DB2 SQL command, you can provide DataAccess to user on Database in DB2 with DBADM Privilege

GRANT DBADM WITH DATAACCESS ON DATABASE TO user1
 
 
        DBADM authority is an administrative authority for a specific database. The database administrator possesses the privileges required to create objects and issue database commands. In addition, users with DBADM authority have SELECT privilege on the system catalog tables and views, and can execute all system-defined DB2® routines, except audit routines.


No comments:

Post a Comment