Re: Restrict View data access to some users only.

Hi

If the users that you have log into the oracle database using different user names, why don't you look into using oracle Vituel private database.

Using this feature you can restrict some users to only see specific data, without changing the application, and even with out the users being able to see this limitation.

Best regards
  Rene

"manjsuha" <manjushavenkat_at_gmail.com> skrev i en meddelelse news:1163995660.703825.212230_at_e3g2000cwe.googlegroups.com...
> 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 Thu Nov 23 2006 - 19:43:06 CST