UserAdmin
The UserAdmin package allows you to create and drop users and grant and revoke privileges. Using procedural replication, this package provides a means to maintain user accounts in multiple databases without having to actually log into each database to perform the administrative tasks. The package is quite lengthy and is already included in Chapter 14 (see Section 14.5.1, Section 14.5.2, and Section 14.5.3), so I have not duplicated the code here. However, you will find it at the O’Reilly web site.
Get Oracle Distributed Systems now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
