Re: Problem with privileges
->Date: Fri, 21 Jan 94 15:24:45 EST
->From: Mike Goodrich <goodrich@sirius.larc.nasa.gov>
->To: alan@po.den.mmc.com
->Subject: Re: Problem with privileges
->
->Thanx four help. I have tried the things you mentioned to no avail. Also
->how does one determine the exsisting views? There doesn't seem to be any
->way to list them...
->
->-Mike
To find views:
SELECT * FROM systables
WHERE tabtype = 'V';
To list views:
SELECT tabname, seqno, text
FROM systables t, sysviews v
WHERE tabtype = 'V'
AND t.tabid = v.tabid
ORDER BY tabname, seqno;
Info in syscolumns, systabauth, syscolauth appears for views, just as for
tables.
Regards,
Alan ___________________________
______________________| R. Alan Popiel |__________________________
\\ Internet: | Martin Marietta, SLS | /
\\ alan@den.mmc.com | P.O. Box 179, M/S 3810 | Std disclaimers apply. /
)Voice: | Denver, CO 80201-0179 USA | (
/ 303-977-9998 |___________________________| (But you knew that!) \\
/________________________) (____________________________\\