Home > IT Answers > Security > How to implement row level security
ON
5 pts.
 How to implement row level security
Database security, Row Level Security
implementing roe level srcurity

Software/Hardware used:
ASKED: May 14, 2009  6:07 AM
UPDATED: July 29, 2009  4:36 PM
RELATED QUESTIONS
Answer Wiki:
Hello, as the moderator said you could have added some additional info, but in general one can implement row level locking by specifying locksize parm on the CREATE TABLESPACE or CREATED TABLE statement (depending on which RDBMS you are using.)
Last Wiki Answer Submitted:  July 29, 2009  4:10 pm  by  Meandyou   5,205 pts.
All Answer Wiki Contributors:  Meandyou   5,205 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Moderator Note: Hello ON and welcome to IT Knowledge Exchange. Please provide more details when you post a question, so that other members can see the platform, software, version etc. that you are using. Are you asking about Oracle, SQL Server or what? You can provide more details by clicking the “Add to Discussion” button to leave a comment. I added an extra tag of “Database security” but its best to always use the software you’re using as a tag (i.e. Oracle 10g, SQL Server 2005, etc.) so that your question appears in that section of the site. Thanks!

BrentSheets
 6,580 pts.
 

I don’t think the question was about locking rows, but about restricting or granting access to specific rows.

If that was the case, here are some reference links:

Oracle Row Level Security
Implementing Row- and Cell-Level Security in Classified Databases Using SQL Server 2005

carlosdl
 63,580 pts.