How to implement row level security

5 pts.
Tags:
Database security
Security
implementing roe level srcurity

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.)

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • BrentSheets
    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!
    6,925 pointsBadges:
    report
  • carlosdl
    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
    69,990 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following