Home » SQL & PL/SQL » SQL & PL/SQL » Permission (Oracle 9i)
Permission [message #449074] Fri, 26 March 2010 09:19 Go to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
Hi Experts,

I have two schemas.In schema1 i hava a table with 20 records,
i want to give access only on 10 th row for schema2.

How can we do that please help me.


Thanks in advance.


Re: Permission [message #449076 is a reply to message #449074] Fri, 26 March 2010 09:22 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
Create a view that selects the required row, grant select on that view to other schema.
Re: Permission [message #449077 is a reply to message #449074] Fri, 26 March 2010 09:23 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
rows in a table are like balls in a basket.
Which is 10th ball in the basket?
Re: Permission [message #449096 is a reply to message #449077] Fri, 26 March 2010 10:58 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
BlackSwan wrote on Fri, 26 March 2010 09:23
rows in a table are like balls in a basket.
Which is 10th ball in the basket?


Laughing
Re: Permission [message #449112 is a reply to message #449074] Fri, 26 March 2010 13:46 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
Just like ALL of your generic basic questions, look in the documentation. you may want to look at Fine Grained Access Control.
Did you ever look in the documentation for anything...ever? How did you even know how to use Oracle?
Re: Permission [message #449115 is a reply to message #449112] Fri, 26 March 2010 14:00 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>How did you even know how to use Oracle?
I know how to point & click mouse!

GUI is as GUI does. (paraphrased from Forest Gump)
Re: Permission [message #449178 is a reply to message #449074] Sat, 27 March 2010 11:30 Go to previous message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
All kiding aside, Joy and Cookiemonster have given you the answer, user views and/or Fine Grained Access Control aka. Virtual Private Database. You will need to do considerable reading on these topics if you wish to achieve a good result.

Kevin
Previous Topic: "Table inheritance" in Oracle
Next Topic: can function return multiple rows
Goto Forum:
  


Current Time: Fri Dec 09 15:07:58 CST 2016

Total time taken to generate the page: 0.10148 seconds