At 09:52 PM 25/03/2008, you wrote:

>Thanks for reply -
>I had come to the same conclusion you suggested. Once I remove grants
>to public I should have my problem solved. In my senario a user will
>only be assigned one role so I will return only one record. All I
>need to do is close connection and reopen with role assigned that was
>return from sql select;

Don't count on being able to do this permanently. It's not a good situation that any user can access the system tables and it is on the agenda to make it not possible. I didn't suggest it because I don't recommend it even slightly. Use privileges as they are intended: hacks are always risky and this one is A-rated.

./heLen