Home » RDBMS Server » Security » grant select privelege on some rows of table.
grant select privelege on some rows of table. [message #27536] Tue, 14 October 2003 07:24 Go to next message
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.
Re: grant select privelege on some rows of table. [message #27538 is a reply to message #27536] Tue, 14 October 2003 07:49 Go to previous messageGo to next message
Surya
Messages: 34
Registered: December 2001
Member
What abt creating Views and granting select privilege ?

Surya
Re: grant select privelege on some rows of table. [message #27539 is a reply to message #27536] Tue, 14 October 2003 07:51 Go to previous messageGo to next message
Maaher
Messages: 7062
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
Re: grant select privelege on some rows of table. [message #27556 is a reply to message #27536] Wed, 15 October 2003 00:58 Go to previous messageGo to next message
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.
Re: grant select privelege on some rows of table. [message #27558 is a reply to message #27556] Wed, 15 October 2003 01:17 Go to previous messageGo to next message
Maaher
Messages: 7062
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
Re: grant select privelege on some rows of table. [message #27560 is a reply to message #27539] Wed, 15 October 2003 01:31 Go to previous message
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.
Previous Topic: roles and users
Next Topic: Password Verification cursor
Goto Forum:
  


Current Time: Mon Nov 23 16:56:56 CST 2020