OraFAQ Forum: Security » grant select privelege on some rows of table.

Home » RDBMS Server » Security » grant select privelege on some rows of table.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

grant select privelege on some rows of table. [message #27536]

Tue, 14 October 2003 07:24

utsav
Messages: 94
Registered: March 2003

Member

Is it possible to grant select privelege on some rows of table.

That is that the other user should be able to view those rows on which the user has the select privelege.

Report message to a moderator

Re: grant select privelege on some rows of table. [message #27538 is a reply to message #27536]

Tue, 14 October 2003 07:49

Surya
Messages: 34
Registered: December 2001

Member

What abt creating Views and granting select privilege ?

Surya

Report message to a moderator

Re: grant select privelege on some rows of table. [message #27539 is a reply to message #27536]

Tue, 14 October 2003 07:51

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Create a view that selects only those records the user is allowed to view and make a synonym for this user pointing to the view instead of the table. For the user it is transparent. Another option is fine grained access control.

But like I said: use a view.

MHE

Report message to a moderator

Re: grant select privelege on some rows of table. [message #27556 is a reply to message #27536]

Wed, 15 October 2003 00:58

utsav
Messages: 94
Registered: March 2003

Member

The problem with views here is that some condition has to be there for instance where emp_no>2400.

I need some privelege grant select on emp_no 2500 and 2600.

Is this possible.

Report message to a moderator

Re: grant select privelege on some rows of table. [message #27558 is a reply to message #27556]

Wed, 15 October 2003 01:17

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Work with application context and fine grained access control. I never used it myself, so I'll just redirect you.

Here are a couple of links (from Asktom.oracle.com)
1. fined grained access control
2. Fine grained access control
3. FGAC

Search his site. Or, you could read the manuals at Http://tahiti.oracle.com.

MHE

Report message to a moderator

Re: grant select privelege on some rows of table. [message #27560 is a reply to message #27539]

Wed, 15 October 2003 01:31

utsav
Messages: 94
Registered: March 2003

Member

Views will display data based on condition. That condition will also be fixed.
I need a mechanism through which i can grant select on some rows and then revoke and grant again. This is not possibel via view.

Is there any othr way.

Report message to a moderator

Previous Topic:	roles and users
Next Topic:	Password Verification cursor

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 15 05:44:40 CST 2025