Your user also needs to be a local administrator. Check the redbook at http://tinyurl.com/7h88 if you want to know almost everything about DB2 and Windows.
----- Original Message ----- From: "Borgoglio, Francesco" <[EMAIL PROTECTED]> To: "'DB2 Mainframe List'" <[EMAIL PROTECTED]>; "'DB2 Open System List'" <[EMAIL PROTECTED]> Sent: Friday, March 14, 2003 4:04 PM 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
