Auditing an Oracle database for security issues is very important. provides all of the information and tools that you will need Click here for details of Limited's detailed Oracle database security audit service Click here for details of Limited's Oracle Security Training Courses
There are 53 visitors online    
Cookie Policy:We only use essential cookies on small sections of this website. For details see here.

Pete Finnigan's Oracle security weblog

Home » Archives » December 2004 » Role based security management in Oracle designer

[Previous entry: "XML DB Beta program for Oracle 10g release 2"] [Next entry: "A free Perl based Log Analysis tool"]

Role based security management in Oracle designer

December 29th, 2004 by Pete

I saw this evening a very interesting post from Lucas Jellema on the Amis blog. The post is titled "Enabling Role-based security management in Oracle Designer 6i/9i/10g through the Repository Object Browser" and is well worth a read. Lucas starts by telling us of the overwhelming task involved in managing users and privileges across many applications and folders. He also explains how difficult it is to add new developers to projects unless the Repository Object Browser (ROB) is installed.

Lucas tells us some of the history of Oracle designer web assistant and the fact that roles are not fully tested (implemented?) and that ROB is available as are roles but can they be used or not?

Lucas goes on to tell us how to re turn on support for repository roles and as he says switch off product support. He goes on to talk about working with roles, creating roles, granting roles, granting roles to other roles and users, reconciling roles, revoking roles, revoking privileges and deleting roles.

This is a very thorough and interesting article and well worth reading. Again it can be found here.

December 2004

This is the weblog for Pete Finnigan. Pete works in the area of Oracle security and he specialises in auditing Oracle databases for security issues. This weblog is aimed squarely at those interested in the security of their Oracle databases.

Weblog Home
Weblog Archives

Oracle Security Tools page
Oracle security papers
Oracle Security alerts

Web Development
SQL Server Security

Atom 0.3 FEED
Powered by gm-rss 2.0.0

Valid XHTML 1.0!