Select authority on view

Grace Chen

Select authority on view
Hi List,
If a user id has select authority on the base table, does it get select
authority on the view which created from this base table automatically?
This user id is different from the qualifier of the base table and different
from the qualifier of the view.

Grace Chen




---------------------------------------------------------------------------------
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

[login to unmask email]

Re: Select authority on view
(in response to Grace Chen)
No, You need to grant access to the view for the user (or secondary
authid).

Carol Sutfin
Corporate DBA
AmSouth Bank
(205)261-5214
[login to unmask email]




"Grace Chen"
<[login to unmask email] To: [login to unmask email]
RO.CA> cc:
Sent by: "DB2 Subject: Select authority on view
Data Base
Discussion List"
<[login to unmask email]
.ORG>


12/24/2003 10:56
AM
Please respond
to "DB2 Database
Discussion list
at IDUG"





Hi List,
If a user id has select authority on the base table, does it get select
authority on the view which created from this base table automatically?
This user id is different from the qualifier of the base table and
different from the qualifier of the view.


Grace Chen




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

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

Grace Chen

Re: Select authority on view
(in response to csutfin@AMSOUTH.COM)
Carol,
Thanks for your reply.

Grace

-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Wednesday, December 24, 2003 10:04 AM
To: [login to unmask email]
Subject: Re: Select authority on view


No, You need to grant access to the view for the user (or secondary
authid).

Carol Sutfin
Corporate DBA
AmSouth Bank
(205)261-5214
[login to unmask email]




"Grace Chen"
<[login to unmask email] To:
[login to unmask email]
RO.CA> cc:
Sent by: "DB2 Subject: Select authority on
view
Data Base
Discussion List"
<[login to unmask email]
.ORG>


12/24/2003 10:56
AM
Please respond
to "DB2 Database
Discussion list
at IDUG"





Hi List,
If a user id has select authority on the base table, does it get select
authority on the view which created from this base table automatically?
This user id is different from the qualifier of the base table and
different from the qualifier of the view.


Grace Chen




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

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

Sushanta K Dash

Re: Select authority on view
(in response to Grace Chen)
The answer is No. You have to follow separately for views.

With thanks
Dash
____________________________________________________________________________
_____________
DB2 / IMS Database Administration Tel: 91 ( 44 )
28113801. X-2366.
India Solution Center
Fax: 91 (44 ) 28113790.
Chennai.
E-mail : [login to unmask email]
"The views expressed are my own and do not necessarily represent the views
or policy of my employer"



-----Original Message-----
From: DB2 Data Base Discussion List [SMTP:[login to unmask email] On
Behalf Of Grace Chen
Sent: Wednesday, December 24, 2003 10:26 PM
To: [login to unmask email]
Subject: Select authority on view

Hi List,
If a user id has select authority on the base table, does it get
select authority on the view which created from this base table
automatically? This user id is different from the qualifier of the base
table and different from the qualifier of the view.

Grace Chen




----------------------------------------------------------------------------
----- 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