Create View Authority ???

Dee Reins

Create View Authority ???
CREATE VIEW CPR_EQPT AS


SELECT CAST(CPRP.EXCH_CODE AS INTEGER) AS EXCH


,CPRS.BLDG


,CPRP.PROP_ID


,CPRP.MFR_CODE


,CPRP.PART_CODE


FROM CTCPRO.TCPCPR CPRP


,CTCPRO.TCPSITE CPRS


WHERE CAST(CPRP.EXCH_CODE AS INTEGER) IN


(0201,0202,9653,9654)


AND CAST(CPRP.EXCH_CODE AS INTEGER) =


CAST(CPRS.EXCH_CODE AS INTEGER)


;


---------+---------+---------+---------+---------+---------+---------+--
-------+

DSNT408I SQLCODE = -551, ERROR: TSXVDRI DOES NOT HAVE THE PRIVILEGE TO


PERFORM OPERATION CREATE VIEW ON OBJECT CTCPRO.TCPCPR



The user TSXVDRI has authority to insert, update, select on table
CTCPRO.TCPCPR

What am I missing.



Thanks

Dee





IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion
listserv that are being implemented to improve reliability and the
overall user experience of DB2-L. These changes are coming on November
30th. Details at http://www.idug.org

------------------------------------------------------------------------
--------- 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". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. 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 IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion
listserv that are being implemented to improve reliability and the
overall user experience of DB2-L. These changes are coming on November
30th. Details at http://www.idug.org

------------------------------------------------------------------------
--------- 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". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. 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 IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion
listserv that are being implemented to improve reliability and the
overall user experience of DB2-L. These changes are coming on November
30th. Details at http://www.idug.org

------------------------------------------------------------------------
--------- 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". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. 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

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

---------------------------------------------------------------------------------
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". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. 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

Philip Sevetson

Re: Create View Authority ???
(in response to Dee Reins)
Hmm. Don't you have to have SELECT...WITH GRANT AUTHORITY in order to create a view with your own creator, which you would then have authority to GRANT privileges on?

--Phil Sevetson, NYCAPS DBA Support
Financial Information Services Agency of The City of New York
450 West 33rd Street, 4th Floor
New York, NY 10001
phone: (212) 857-1688
mailto: [login to unmask email]
________________________________________
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Dee Reins
Sent: Thursday, November 29, 2007 3:43 PM
To: [login to unmask email]
Subject: [DB2-L] Create View Authority ???

  CREATE VIEW CPR_EQPT AS                                                      
    SELECT CAST(CPRP.EXCH_CODE AS INTEGER) AS EXCH                             
          ,CPRS.BLDG                                                           
          ,CPRP.PROP_ID                                                        
          ,CPRP.MFR_CODE                                                       
          ,CPRP.PART_CODE                                                      
    FROM   CTCPRO.TCPCPR  CPRP                                                 
          ,CTCPRO.TCPSITE CPRS                                                 
    WHERE  CAST(CPRP.EXCH_CODE AS INTEGER) IN                                  
             (0201,0202,9653,9654)                                              
      AND  CAST(CPRP.EXCH_CODE AS INTEGER) =                                   
           CAST(CPRS.EXCH_CODE AS INTEGER)                                     
    ;                                                                           
---------+---------+---------+---------+---------+---------+---------+---------+
DSNT408I SQLCODE = -551, ERROR:  TSXVDRI DOES NOT HAVE THE PRIVILEGE TO        
         PERFORM OPERATION CREATE VIEW ON OBJECT CTCPRO.TCPCPR 

The user TSXVDRI has authority to insert, update, select on table CTCPRO.TCPCPR
What am I missing.

Thanks
Dee  
              



=========
Confidentiality Notice: This e-mail communication, and any attachments, contains confidential and privileged information for the exclusive use of the recipient(s) named above. If you are not an intended recipient, or the employee or agent responsible to deliver it to an intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify me immediately by replying to this message and delete this communication from your computer. Thank you.

Any opinions, expressed or implied, presented are solely those of the author and do not necessarily represent the opinions of the agency or the City.
=========



IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

---------------------------------------------------------------------------------
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". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. 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