| Need Help Urgently..... [message #180634] |
Tue, 04 July 2006 08:35  |
itzsalil@gmail.com
Messages: 1
Registered: July 2006
Location: Pune
|
Junior Member |
|
|
Dear All,
I want to implement the following ...
suppose there is a table in Oracle 9i created on the system schema by system user on which is range partitioned over dates and every partition resides on a different Tablespace.
I have also created users having those tablespaces as thier default ones ...
Now i want the following to happen ..
When i login through a user (except system) i want him to see only that data which resides in his default tablespace ...
Is this possible ....
if so .. please help me out .. may be I am missing some grants or denials of permisssion ...
Looking forward to ur response ..
THank you.
|
|
|
|
|
|
| Re: Need Help Urgently..... [message #184517 is a reply to message #180634] |
Wed, 26 July 2006 19:20  |
anurag078
Messages: 34
Registered: May 2006
Location: West Des Moines
|
Member |
|
|
You dont need to do anything...
You (a non system user) can see only those objects owned by you, irrespective of
the tablespace in which it is created.
If the objects are owned by System, and even if it is in the same tablespace,
on which you have default tablespace privileges, unless explicitly granted
by object privileges on those system objects, you can not see those objects.
|
|
|
|
| Re: Need Help Urgently..... [message #184536 is a reply to message #184517] |
Wed, 26 July 2006 23:40 |
lzulueta
Messages: 10
Registered: July 2006
Location: Philippines
|
Junior Member |
|
|
The only opitons I know will work is to use label security (need to pay extra for this) or FGAC/RLS (you need to manually add policies, create several objects to make this work). If you go with FGAC/RLS I'd suggest creating policies with the same condition you used to define the partition...
Just message if you need more information about this.
|
|
|
|
) 1 Vote
] 
Blog
Search
Help
Members
Register
Login
Home
