"Rene S. Nielsen" <rsnfjernspam_at_adds.dk> wrote in message
news:45664e35$0$3458$edfadb0f_at_dread11.news.tele.dk...
> 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,
>>
>
>Why don't you have read at the whole thread ?
Received on Thu Nov 23 2006 - 20:34:50 CST
