DB2/QMF v7.2

Steve Whittaker

DB2/QMF v7.2
Got a question when using QMF Version 7 Release 2.
We are using DB2 v7 on OS/390 v2.10.
When a user displays his result set after running a query he enters 'SAVE DATA AS abc' and hits enter. He then gets an authoriation error msg saying he's not authorized to save data in this database.
I checked his QMF PROFILE (PF11) and the DATABASE/TABLESPACE names are plugged in correctly. I looked at the SYSIBM.SYSDBAUTH catalog and he has CREATETABAUTH & CREATETSAUTH for this database. Sooooo, why in the world will it not let him save data. Now if I put the database/tablespace name back to the QMF DEFAULT names then it works just fine.
Any ideas of why his authorization keeps failing when we change the default database/tablespace name?? Also we have about 12 other people who have authority to this new database/tablespace and they work just fine. Is there something obvious that I'm missing.

Thanks:
--Steve....

Steve Whittaker
email: [login to unmask email]
Ph: 919-546-7267

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Tim Birk

Re: DB2/QMF v7.2
(in response to Steve Whittaker)
Have you checked SYSRESAUTH to make sure the user has use authority on
the tablespace?

-----Original Message-----
From: Whittaker, Stephen [mailto:[login to unmask email]
Sent: Monday, December 15, 2003 1:54 PM
To: [login to unmask email]
Subject: DB2/QMF v7.2

Got a question when using QMF Version 7 Release 2.
We are using DB2 v7 on OS/390 v2.10.
When a user displays his result set after running a query he enters
'SAVE DATA AS abc' and hits enter. He then gets an authoriation error
msg saying he's not authorized to save data in this database.
I checked his QMF PROFILE (PF11) and the DATABASE/TABLESPACE names are
plugged in correctly. I looked at the SYSIBM.SYSDBAUTH catalog and he
has CREATETABAUTH & CREATETSAUTH for this database. Sooooo, why in the
world will it not let him save data. Now if I put the
database/tablespace name back to the QMF DEFAULT names then it works
just fine.
Any ideas of why his authorization keeps failing when we change the
default database/tablespace name?? Also we have about 12 other people
who have authority to this new database/tablespace and they work just
fine. Is there something obvious that I'm missing.

Thanks:
--Steve....

Steve Whittaker
email: [login to unmask email]
Ph: 919-546-7267

------------------------------------------------------------------------
---------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". If you will be out of the office,
send the SET DB2-L NO MAIL command to [login to unmask email] The
IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Steve Whittaker

Re: DB2/QMF v7.2
(in response to Tim Birk)
What I found out was that this userid had 2 row entries in the sysdbauth catalog. 1 row for CREATETAB and 1 row for CREATETS. I revoked this access and reissued the grant stmt so that only '1' row exists in the catalog giving him createtab & createts. Sure enough it now WORKS.
I had looked right past his id having 2 rows and thought that it would still work. But guess I was wrong.

Thanks:
--Steve....

-----Original Message-----
From: Birk, Tim [mailto:[login to unmask email]
Sent: Monday, December 15, 2003 2:05 PM
To: [login to unmask email]
Subject: Re: DB2/QMF v7.2


Have you checked SYSRESAUTH to make sure the user has use authority on
the tablespace?

-----Original Message-----
From: Whittaker, Stephen [mailto:[login to unmask email]
Sent: Monday, December 15, 2003 1:54 PM
To: [login to unmask email]
Subject: DB2/QMF v7.2

Got a question when using QMF Version 7 Release 2.
We are using DB2 v7 on OS/390 v2.10.
When a user displays his result set after running a query he enters
'SAVE DATA AS abc' and hits enter. He then gets an authoriation error
msg saying he's not authorized to save data in this database.
I checked his QMF PROFILE (PF11) and the DATABASE/TABLESPACE names are
plugged in correctly. I looked at the SYSIBM.SYSDBAUTH catalog and he
has CREATETABAUTH & CREATETSAUTH for this database. Sooooo, why in the
world will it not let him save data. Now if I put the
database/tablespace name back to the QMF DEFAULT names then it works
just fine.
Any ideas of why his authorization keeps failing when we change the
default database/tablespace name?? Also we have about 12 other people
who have authority to this new database/tablespace and they work just
fine. Is there something obvious that I'm missing.

Thanks:
--Steve....

Steve Whittaker
email: [login to unmask email]
Ph: 919-546-7267

------------------------------------------------------------------------
---------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". If you will be out of the office,
send the SET DB2-L NO MAIL command to [login to unmask email] The
IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Bill Kebea

Re: DB2/QMF v7.2
(in response to Steve Whittaker)
Have you granted 'use of tablespace' to 'user'

Bill Kebea
732-225-8096



"Birk, Tim"
<[login to unmask email] To: [login to unmask email]
OM> cc:
Sent by: DB2 Subject: Re: DB2/QMF v7.2
Data Base
Discussion List
<[login to unmask email]
.ORG>


12/15/2003 02:04
PM
Please respond
to DB2 Database
Discussion list
at IDUG






Have you checked SYSRESAUTH to make sure the user has use authority on
the tablespace?

-----Original Message-----
From: Whittaker, Stephen [mailto:[login to unmask email]
Sent: Monday, December 15, 2003 1:54 PM
To: [login to unmask email]
Subject: DB2/QMF v7.2

Got a question when using QMF Version 7 Release 2.
We are using DB2 v7 on OS/390 v2.10.
When a user displays his result set after running a query he enters
'SAVE DATA AS abc' and hits enter. He then gets an authoriation error
msg saying he's not authorized to save data in this database.
I checked his QMF PROFILE (PF11) and the DATABASE/TABLESPACE names are
plugged in correctly. I looked at the SYSIBM.SYSDBAUTH catalog and he
has CREATETABAUTH & CREATETSAUTH for this database. Sooooo, why in the
world will it not let him save data. Now if I put the
database/tablespace name back to the QMF DEFAULT names then it works
just fine.
Any ideas of why his authorization keeps failing when we change the
default database/tablespace name?? Also we have about 12 other people
who have authority to this new database/tablespace and they work just
fine. Is there something obvious that I'm missing.

Thanks:
--Steve....

Steve Whittaker
email: [login to unmask email]
Ph: 919-546-7267

------------------------------------------------------------------------
---------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". If you will be out of the office,
send the SET DB2-L NO MAIL command to [login to unmask email] The
IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------

Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
can be reached at [login to unmask email] Find out the latest on
IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm