OraFAQ Forum: Security » Grant select to a view but not the underlying table

Home » RDBMS Server » Security » Grant select to a view but not the underlying table

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

Grant select to a view but not the underlying table [message #12643]

Fri, 28 May 2004 13:50

Rick Berning
Messages: 2
Registered: May 2004

Junior Member

Various places I've read that views are�good because you can provide filtered data rather than access to the�base data tables.� But if the user does not have select privileges for the�base table, how can they be effectively granted for the view based on that table.�� In this case, I do not want the user to see all the data - just a subset.� Is there someway I can�grant select�for the view but do not�grant select for the�base table?��The result is ORA-01031: insufficient privileges when�the user tries to run�the view when they do not have select granted on the�base.� But when I grant select to that user on the�base table then the view will work for them.

Report message to a moderator