Re: Restricting view on all_users

> For instance, I have created a user Neo who in turn has created a user
> Red and Blue. Now I also have created a user Smith. But when Neo does
> a 'select * from all_users' I want him only to see Red and Blue
> without him gaining knowledge of Smith.

To my knowledge, the system does not keep track of which user created which user. The list of users who can issue a CREATE USER statement should be very small anyway (i.e. less than 5). Most users don't have the CREATE USER privilege. So why would one want to know this information?

If this is really desirable, then you'll have to create a trigger which captures CREATE USER statements and log who create who. Then, you'd have to get this information out of this log (stored in a table perhaps).

HTH,
Brian Received on Thu Oct 17 2002 - 09:07:05 CDT