Pete Finnigan's Oracle Security Weblog

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.