Database IT Blogs

Articles, tips and tricks for databases
Tags >> security
postgresql-chanel The PostgreSQL Project today released minor versions updating all active branches of the PostgreSQL object-relational database system, including versions 8.4.2, 8.3.9, 8.2.15, 8.1.19, 8.0.23, and 7.4.27.

Patrick Barel When you apply Row Level Security to a table, which has constraints, like a primary key or a unique constraint, then these constraints are evealuated regardless of the RLS policy. Of course this makes sense, especially in the case of a primary key, but it can be a problem with a unique constraint.

Read the entire article at: http://bar-solutions.com/wordpress/?p=10

Tagged in: security , oracle database , DBAs

Advertisement

Featured Links:
DreamCoder for MySQL Enterprise
Powerful MySQL GUI Client tool designed to automate and simplify database development process.
DreamCoder for Oracle DBA
Top IDE for Developers & DBAs. Browse database objects, run SQL and SQL scripts, and edit and debug PL/SQL code.
DreamCoder for PostgreSQL Enterprise
Powerful PostgreSQL admin tool. PLpg/SQL IDE for developers and DBAs.

Tags