At 01:19 PM 14/01/2005 +0000, you wrote:

>Another quick question about roles...
>
>Is there any way to remove object creation rights from a user role?
>
>I see there are object level (e.g. select, update, delete etc)
>privileges but what about database level privileges (e.g. create
>table, create procedure etc)? How do I restrict these for a user's role?

Role -- and SQL privileges generally - don't have any part to play in the
creation of objects. Currently, any authenticated user (including one who
has NO privileges whatsoever in the database so far) can create objects in
the database.

./heLen