Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Restrict View data access to some users only.
Nasser,
It is not possible to create a view with the same name as base table, because views and tables are in the same namespace.
Thanks
Manjusha
wannabe DBA wrote:
> Beto,
>
> I think you are on the right lines. Create a view with the same name as
> the base table, i think oracle allows you to create objects with the
> same name but only if the object type is different. Hence a view or
> table in the same schema with the same name is do'able.
>
> When you create this new view, you should 'create roles' that restrict
> access to the table and the view. Then you should give those roles to
> either the responsibilities or to the users appropriately. That way,
> for the users you want to give access for the full year you give them
> the role for the table, and for the users you want to give access to
> only 6 months of data you give them the role to the view.
>
> Regards!
>
> WDBA
> On 18 Nov, 10:17, "Beto" <andred..._at_hotmail.com> wrote:
> > Hi All ,
> >
> > I need a help from the experts!
> >
> > First of all , is it possible to create two view with same name?
> >
> > Let's try to explain...
> >
> > Today i have one view that store data for a period of 1 year and i
> > have some clients that access these data.
> > I want to restrict this period to 6 months only , but only to one
> > client (for example Client application A).
> > For example , through the Client A today i can check the bills from a
> > periof of one year , but i want to restrict to 6 month , so the Client
> > A will be allowed to check only bills from 6 months.
> >
> > So i was thinking to create another view with the same name with
> > condition to store data only for a period of 6 month .
> >
> > I don't know how to make that only users from Client Application A
> > access this new view.
> >
> > I have a table that stores all users that access the client application
> > A.
> >
> > Any other suggestions to restrict the Client A access to period of 6
> > month only without creating new view wil help me a lot!
> >
> > TIA!
> >
> > rgds,
Received on Sun Nov 19 2006 - 22:07:40 CST