Here's what is going on. The get dbm cfg, update dbm cfg, reset dbm cfg commands can all be issued when the instance is NOT active. So, the dbm cfg cannot be seen by the command interpreter. Even if you make the db2admin a member of SYSADM_GROUP, that info is in the dbm cfg that the command does not see!! In order for your get, update, reset dbm cfg command to work (this is true also for: db2icrt, db2idrop, dasicrt, dasidrop) the id you logon with must be a LOCAL NT Administrator. HTH, Pierre. ----- Original Message ----- From: "Borgoglio, Francesco" <[EMAIL PROTECTED]> To: "'DB2 Mainframe List'" <[EMAIL PROTECTED]>; "'DB2 Open System List'" <[EMAIL PROTECTED]> Sent: Friday, March 14, 2003 10:04 AM Subject: [DB2EUG] The right grant to get snapshot 2
> Hi all. > I hope i will be a little more understandable now. > > This is my situation. > If i apply the command "get dbm cfg" i receive the result: > ............................................................................ > .... > ............................................................................ > .... > SYSADM group name (SYSADM_GROUP) = DBA > SYSCTRL group name (SYSCTRL_GROUP) = DBA > SYSMAINT group name (SYSMAINT_GROUP) = DBA > ............................................................................ > .... > ............................................................................ > .... > > Where DBA is the local group which the user DB2ADMIN belongs to. > > But if i apply the command "get authorizations" for any db of the dbm, i > obtain for the user DB2ADMIN: > > Direct SYSADM authority = NO > Direct SYSCTRL authority = NO > Direct SYSMAINT authority = NO > Direct DBADM authority = YES > Direct CREATETAB authority = YES > Direct BINDADD authority = YES > Direct CONNECT authority = YES > Direct CREATE_NOT_FENC authority = YES > Direct IMPLICIT_SCHEMA authority = YES > Direct LOAD authority = YES > > Indirect SYSADM authority = NO > Indirect SYSCTRL authority = NO > Indirect SYSMAINT authority = NO > Indirect DBADM authority = NO > Indirect CREATETAB authority = YES > Indirect BINDADD authority = YES > Indirect CONNECT authority = YES > Indirect CREATE_NOT_FENC authority = NO > Indirect IMPLICIT_SCHEMA authority = YES > Indirect LOAD authority = NO > > I think i should i read > "Indirect SYSADM authority = YSE > Indirect SYSCTRL authority = YSE > Indirect SYSMAINT authority = YES" > didn't I???? > > Can anyone help me? > > > Thank you so much. > > > > -----Messaggio originale----- > > Da: Borgoglio, Francesco > > Inviato: Friday, March 14, 2003 10:10 AM > > A: 'DB2 Mainframe List'; 'DB2 Open System List' > > Oggetto: The right grant to get snapshot > > > > Hi all, > > i'm trying to apply the command "get snapshot for all on mydb", > > (on a WINNT 4.0 platform, DB2 UDB 7.2), > > and i receive the following error: > > SQL1092N "DB2ADMIN" does not have the authority to perform the requested > > command. > > I granted the sysadm, sysctrl and sysmaint to the group which DB2ADMIN > > belong to, > > but nothing improves. > > What kind of privilege do i have to grant to? > > > > Thank you so much. > > > > > > > > True ignorance is not the absence of knowledge, > > but the refusal to acquire it. > > > > > - > ::: When replying to the list, please use 'Reply-All' and make sure > ::: a copy goes to the list ([EMAIL PROTECTED]). > *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] > *** For more information, check http://www.db2eug.uni.cc > - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
