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