Grant access to DB2 objects

jeevajeeva · New User Joined: 13 May 2006 Posts: 17

hi,

how to grant access to all the storage groups,databases,plans,packages at one shot

i tried to use the following but it wont accept

grant all on package *.* to auth-id;

any please give me the correct code to do this

Hanfur · Active User Joined: 21 Jun 2006 Posts: 104

I must think that what you require is to issue GRANT all rights to all databases which comes under an Instance..

In that case Update Database confuguration file(INSTANCE level) to add those users in to any of the following user groups SYSCNTRL or SYSMAINT

-Han.