Q
Problem solve Get help with specific problems with your technologies, process and projects.

Restricting certain statements on tables

I need to put some restrictions on my database tables. Say, for example, I want to prevent statements like "select * from table;" but allow statements like "select column from table;". How do I do this?

I need to put some restrictions on my database tables. Say, for example, I want to prevent statements like "select * from table;" but allow statements like "select column from table;". How do I do this? Thanks for your help.
I've never seen this type of requirement before. But if I had to implement this, about the only way I can think of is to use Oracle's Fine Grained Access Control (FGAC) to help you out. With FGAC (also known as Virtual Private Database or VPD), you can limit individuals from accessing certain columns in a table. So create a new column in the table and ensure that no one can query values out of that column. When FGAC sees "SELECT *", it will not let the query execute. So long as the query does not include this limited column, the query will go through just fine. You'll have to do this for every table that you want to limit your queries on. You will want to weigh this solution very carefully as you are adding overhead to your query processing that may impact application performance.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close