Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Can't create view

Re: Can't create view

From: Jan Schaefer <schaefer_at_kksl.uni-leipzig.de>
Date: Wed, 30 May 2001 09:22:29 +0200
Message-ID: <9f273b$k5n$1@news.uni-leipzig.de>

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> schrieb im Newsbeitrag news:th4bubgs62iaa5_at_beta-news.demon.nl...

>

> Views are compiled, and roles are not observed during compilation as roles
> are volatile.
> In short: if it does work at compilation, there's no guarantee
> it will continue to work.

Same problem with direct grants. If I revoke the direct grant to one user then his/her views don't work either. I don't see any difference. Received on Wed May 30 2001 - 02:22:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US