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 -> User dependened views

User dependened views

From: Carsten Baeumchen <carsten.baeumchen_at_gmx.de>
Date: Fri, 03 Nov 2000 19:08:26 +0100
Message-ID: <3A02FF1A.4A61BB6B@gmx.de>

Hi there,

I have got the following problem:

I use some special type of views that are accessible to every user. Every user is able to open/read the view. Now I have the problem that when different user execute this view-sql the content is replaced by the new query conditions.

i.e. User one opens the view with a certain "where" condition, then user 2 does the same with another condition, then content 1 is replaced because of the same
name of the view.

My question: is there a way to store this view by a user dependet view name : "user".ViewAccounts.

The sql statement should be able to integrated the current logged user name into the main view name. This must happen automatically. Maybe something like that "create or replace view 'username'.ViewAccounts ..."

The result should look like

Bert.ViewAccounts
Peter.ViewAccounts
DBA.ViewAccounts
....

Thanks a lot
Carsten Received on Fri Nov 03 2000 - 12:08:26 CST

Original text of this message

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