Call: +44 (0)1904 557620 Call

Pete Finnigan's Oracle Security Weblog

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.

[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

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.