>>>>> "rajan" == rajan <vgmon...@gmail.com> writes:
rajan> Andrew, rajan> Another question, If the user student is not the owner of the rajan> Schema(additional) and has only USAGE / no privileges, How come rajan> it is able to modify permissions at schema level? Because it's not modifying anything that affects any other user. If "student" can't create objects in schema "additional", then the default has no effect (since it applies only to objects created by "student"); if those permissions are later granted, then the previously set default still applies. -- Andrew (irc:RhodiumToad)